How do I do this sql select statement

[cgchris99]

I need to verify some children records to a parent record

 

I need to do a select in my detail file will call DetA to see if there is NOT a match if HeaderA

 

I only want the detail records that do not have a Header.  Does this make sense?

 

How can I do this?

 

I am trying to get this info so I can delete the child records that don't have a matching parent.

 

Thanks

 

[btherl]

To match records that do not exist in another table:

 

SELECT * FROM tableA LEFT JOIN tableB ON (tableA.joincol = tableB.joincol) WHERE tableB.joincol IS NULL

[cgchris99]

Thanks, I'll give that a try.