blob: e89e52ca184301a5eb5b8d9247b35965cff86b1d [file] [log] [blame]
select t1.columns[0], t2.columns[0]
from `oneColDupsWnulls.csv` t1, `oneColWOnulls.csv` t2
WHERE t1.columns[0] = t2.columns[0] OR ( t1.columns[0] IS NULL AND t2.columns[0] IS NULL );