Find Items in one Column not in the Other with MySQL
Super awesome query that puts MS Excel to shame!
SELECT * FROM Table1 WHERE Table1.principal NOT IN (SELECT principal FROM table2)
with data export to file:
SELECT * INTO OUTFILE "c:/mydata.csv" FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY "\n" FROM Table1 WHERE Table1.principal NOT IN (SELECT principal FROM table2)
