SQL advice

[ondohotola]

Given two CSV files with differing headers headers and differing number of records how do I find the ones in the bigger one that are not in the smaller one, using a column (of names) in each?

[ondohotola]

figured it out

[datatraveller1]

Hi @ondohotola, if you don't mind can you show your solution? 😃

[ondohotola]

something like

SELECT t1.* FROM largertable t1 
WHERE t1.some NOT IN (SELECT t2.another FROM smallertable t2);