Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Update with Join Question......

Re: Update with Join Question......

From: <amerar_at_iwc.net>
Date: 31 Mar 2005 08:11:49 -0800
Message-ID: <1112285509.392298.320390@g14g2000cwa.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US