>>
>>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.