View Single Post
  #1  
Old May 28th, 2010, 08:02 PM posted to microsoft.public.access.queries
sebastico
external usenet poster
 
Posts: 74
Default Delete records from second table

Hello
I have two Tables.
tblMain(MainID)
tblSec(FamID, Group, MainID)
MainID has same attribute in both tables
tblMain has the correct records.

How can I delete all records from tblSec not present in tblMain? Could you
tell me the kind of query. I'm studying Relational Algebra by myself and this
example would help me to learn
Thanks in advance