Ah, that question. Did you try the suggestions of the others who
responded?

--
Martijn

> Hi Martijn,
>
> sorry for reposting..
>
>
> this is my query:
> -----------------
>
> Hello,
> i have two tables .
>
> table 1
>
> id name no
>
> table 2
>
> id no
>
> table 2's id field is referenced to table 1's id field .
>
>
> now i want to retrieve the records from table 1 and no not in
> table 2.
>
> 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.
>
>
> If i rearrange this query to
>
> select * from table1 a where
> a.id not in (select id from
> table2 b where a.id=b.id and a.no=b.no)
>
>
> Will it work fine????
> And my dba is telling that don't use "ot in".
> without "not in" how can i write this query??