Hi,

At April 16, 2003, 09:53, sivram_mail wrote:

>this is the query which is written:
>-----------------------------------
>select * from table1 where id not in
>(select id from table2,table1 where table1.no=table2.no )

>In this query , there is no join condition for primary key.

Try:

select * from table1 where not exists
(select * from table2 where table2.no=table1.no )

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)