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

Home -> Community -> Usenet -> c.d.o.server -> Re: Updating values from one table to another..plz help

Re: Updating values from one table to another..plz help

From: Bert Scalzo <bscalzo01_at_7-11.com.xxx>
Date: Wed, 7 Oct 1998 13:39:23 -0500
Message-ID: <6vgcev$t24$1@news.ses.cio.eds.com> 





You don't have to concatenate:



update A set pager =


(select pager from B where B.fname = A.fname and B.lname=A.lname)
where (fname,lname) IN (select fname,lname from B);



Received on Wed Oct 07 1998 - 13:39:23 CDT












Original text of this message













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