Query question

[ITbeast]

I'm trying create a report that shows all records that don't have a relationship to a record in another table. Can someone think of a way I can do this?

main_table
name_table

linked on id_number

want to see all records in main table that don't have a relational record in name_table

 

[jrbarnett]

SELECT main_table.*
FROM main_table LEFT OUTER JOIN name_table
ON main_table.id_number = name_table.ID_NUMBER
WHERE name_table.id_number IS NULL

John