deleting orphans

  • Thread starter Thread starter JethroUK©
  • Start date Start date
J

JethroUK©

i'm struggling to delete some 50-60 student records from a one (students) to
many (qualifications) query - the orphans are the students without a qual

only way i can find these students is to include quals side, produce all
students and search for nulls (QualID) - but it wont let me run a delete
(because there's two tables in the query)?

help!
 
I believe that you identify the records to be deleted by using a query in
the where clause and NOT EXISTS keywords.
 
Back
Top