Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Update with Join Question......
This is also not working.....
UPDATE A
SET EID = (SELECT EID FROM B)
WHERE (SELECT NBR FROM A WHERE STATUS = 'ABC') =
(SELECT NBR FROM B WHERE AMT > 0);
Received on Thu Mar 31 2005 - 10:11:49 CST