|
about out join of oracle pl/sql
|
=?GB2312?Q?=D6=EC=B2=A5?=
|
Dec 16, 2002 01:13 PST
|
Hello,everyone
Could u give me some tips about the following questions ?
for example :
SELECT PAY_NO. PROJECT_NAME
FROM A
WHERE A.PAY_NO NOT IN
(SELECT PAY_NO
FROM B WHERE VALUE >= 120000);
I can translate it with out joins :
SELECT PAY_NO,PROJECT_NAME
FROM A,B
WHERE A.PAY_NO=B.PAY_NO(+)
AND B.VALUE >= 12000;
----------------------------------------------------
now how to translate the following clause with out joins ?
SELECT PAY_NO. PROJECT_NAME
FROM A
WHERE A.PAY_NO NOT IN
(SELECT PAY_NO
FROM B group by pay_no);
Ok!thanks for your help!
Bobby Zhu
2002/12/16
|
|
 |
|
