>I'm trying to figure out the SQL Syntax to find orphan records in a detail table, that have no counterpart in a parent table. This is something like SELECT all records in TABLE A which don't have a matching record (on a key field) in TABLE B. I can do this with brute force in good 'ol dbase code, but can't SQL do this?
>
>Thanks.
>
>--- L
Ok, I wanted to show the syntax, but you got it already. Just in case for another approach, check FAQ Fastest way to find orphans November 22, 2000 16:44 FAQ #7985