Hello. I have two tables with related id fields. One table has more records than the other. Do you know how I can get the records from the larger table that aren't in the smaller one? <BR><BR>assuming table1 is the larger table...<BR><BR>SELECT table1.id FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE ???