BigQuery | TABLE_DATE_RANGE テーブルに対して JOIN 出来ない ref: http://qiita.com/YumaInaura/items/bcb299dfcbdbbabb608d

file0.sql

SELECT
  *
FROM
  TABLE_DATE_RANGE(single.woman, TIMESTAMP('2016-12-24'), TIMESTAMP('2016-12-25') ) AS woman
LEFT JOIN
  [single.man] AS man
ON
  woman.left_hand = man.right_hand

file1.sql

SELECT
  *
FROM (
  SELECT
    *
  FROM
    TABLE_DATE_RANGE(single.woman, TIMESTAMP('2016-12-24'), TIMESTAMP('2016-12-25') ) AS woman
LEFT JOIN
  [single.man] AS man
ON
  woman.left_hand = man.right_hand