mySQL query help (quick)

[msyKYLE]

Does anyone know how to write the following SQL query to be compatible with mySQL?

SELECT table1.* FROM table1 WHERE NOT table1.primaryid IN (SELECT table2.primaryid FROM table2)

Thanks!

[msyKYLE]

Found my answer....

SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE table2.id IS NULL;