Yes, I was trying both the 'NOT EXISTS' and the 'IN' method but I was seriously fooled because I was testing it on a view (buffered) because VFP 'SELECT's from the base and not the buffer I was not getting the results I had expected.
>Hi geoff,
>
>Amazingly noone mentioned the obvious.
>
>SELECT * FROM a WHERE NOT EXISTS(SELECT * FROM b WHERE a.Fk = a.pk)
>
>Walter,
>
>>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
May all your weeds be wildflowers