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: tricky sql question

Re: tricky sql question

From: Roberto Bruno <rbruno_at_centroin.com.br>
Date: 1997/05/31
Message-ID: <3390A3E0.7085B18B@centroin.com.br>#1/1

 Try rewriting your update as:
update tbl_a set some_column = value
where (key1, key2) in (select key1, key2 from tbl_b where other_column = xyz ) . Received on Sat May 31 1997 - 00:00:00 CDT

Original text of this message

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