Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Basic Issue: Update query based on two tables not working! Any help appreciated!
sorry i mean:
UPDATE tableA
SET PLAN_TYPE = 'L'
WHERE ( OR_ID , DS_ID ) in ( select OR_ID , DS_ID
from tableB )Received on Wed Dec 07 2005 - 05:37:11 CST