Return list where no data exists

[Neil Tompkins]

Hi,
 
I've two tables.  What query do I need to use to get a list of all records from 
table A where table B doesn't contain a a mathing record.  For example
 
TableA
ID
Name
 
TableB
Date
ID
Name
 
Thanks
Neil
_________________________________________________________________
Be one of the first to try Windows Live Mail.
http://ideas.live.com/programpage.aspx?versionId=5d21c51a-b161-4314-9b0e-4911fb2b2e6d