>>>
>>>You may want to use NOT EXISTS subquery:
>>>
>>>

>>>select otest.*, othtest.* ;
>>>from mainbase!otest  ;
>>>Inner Join mainbase!othtest on ;
>>>otest.id=othtest.id ;
>>>where not exists (select 1 from othClients Cl where Cl.fname=otest.fname)

>>
>>
>>ok i see that the '1' is a column but did CL take on the table name?
>
>Did you want to find all records that don't have corresponding names in OthClients table? I used Cl as an alias for that table.

yes
Select * from table

where Not exist( select fname from othclients otest 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