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 -> Update in joined tables???

Update in joined tables???

From: Ståle Veipe <stale_at_veipe.com>
Date: Thu, 18 Jan 2001 22:33:36 +0100
Message-ID: <947n8s$6e8$1@troll.powertech.no> 






I have a script that i cant get to work on oracle isnt this possible to do
on oracle server?



UPDATE tab1 SET tab1.field1=0 FROM tab1 LEFT OUTER JOIN tab2 ON (tab1.id =
tab2.id) WHERE tab2.field2 < 1 AND tab1.field3='Debug'



I can do select this way (not on oracle though). Can this be done? or does
anyone hava another sollution?
Received on Thu Jan 18 2001 - 15:33:36 CST












Original text of this message













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