>>Hello All,
>>I need to select some records from a table that are not present in another table, I've heard you can do this with one of the outer joins but am unsure as to how
>>
>>Regards
>>Pete Kane
>
>Hi,
>
>You need a subquery,
>
>Try something like,
>
>SELECT .* ;
> FROM Tab1 ;
> WHERE KeyField NOT IN ;
> (SELECT DISTINCT KeyField FROM Tab2)
Mark,
thanks, I thought these new inner and outer joins dispensed with sub queries
Regards
Pete Kane
Regards,
Peter J. Kane
Pete