Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: tricky sql question
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
![]() |
![]() |