>Hi
>
>I know I've seen this somewhere but cant seem to find it now I need it.
>
>How do I select records from table A that do not exist in table B?
>
>regards
>Geoff Scott
This is easily solved with a subquery.
select * from TableA where KeyField not in (select KeyField from TableB)
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)