>>Please read this blog explaining the problem in details:
>>
>>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#4
>>
>>(see also corrections I made in the query)
>>
>>>yes

>>>Select * from mytable as oTest
>>where Not exist( select *  from othclients where othclients.fname=otest.fname)

>>>
>>>so the logic is (select the fname from othclients ) whats the Otest there saying then u say when othclients.fname=otest.fname)
>>>if u say equal shouldnt you get name mutual too both tables?then the statment is NOT EXIST...so im confused
>
>
>Corrections?

Yes, I adjusted the query you put to produce the actual result. Click on the view button at the bottom of the thread to view all messages of the thread. You'll be able to see my changes.