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