[RESOLVED] Matching up 2 tables

[netfrugal]

I need to select * from table 1, but only if the unique id is not found in table 2.

$sql = "SELECT c.*, a.* FROM table1 c, table2 a WHERE c.customer_id .............

The customer_id field is what I am matching with. But I'm lost on how to specify ONLY the records from table 1 if I can't find them in table 2.

[netfrugal]

Figured it out!

SELECT * from table1 where customer_id NOT IN (SELECT customer_id from table2)