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 07:55:29 -0800
Message-ID: <1112284529.894867.162390@g14g2000cwa.googlegroups.com> 






This gets me noplace......



UPDATE



  (SELECT A.EID



   FROM



   (SELECT EID, NBR




    FROM A



    WHERE STATUS = 'ABC') A,



   (SELECT EID, NBR




    FROM B



    WHERE AMT > 0) B



   WHERE A.NBR = B.NBR)



SET A.EID = B.EID;

Received on Thu Mar 31 2005 - 09:55:29 CST












Original text of this message













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