Query Help please.

[redneonrt]

I have two MySql tables and I would like a query that selects everything from table 1 but only if the table1.id from table 1 does not exist in table2.id.

Any suggestions?

[craygo]

use left join

[code]$sql = "SELECT fieldname
        FROM table1
        LEFT JOIN table2 ON table1_id = table2_id
        WHERE table2_id IS NULL";[/code]

Ray