>>
>>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.
If it's not broken, fix it until it is.
My Blog