Join Update Query ???
From: James Wj Snyder <snyderj_at_wellsfargo.com>
Date: 1997/11/03
Message-ID: <01bce8b0$fb9279a0$5a4e9797_at_snyderj.wellsfargo.com>#1/1
Date: 1997/11/03
Message-ID: <01bce8b0$fb9279a0$5a4e9797_at_snyderj.wellsfargo.com>#1/1
[Quoted] Hello peoples,
Again Oracle support has been no help <sigh> Anywho...
I need to do an update query based on crieteria from a join. Any help would be appreicated.
Two tables:
TABLE_A
TABLE_B
Update TABLE_A set FIELD_ID = '0001AA' where
TABLE_A.FIELD_A = TABLE_B.FIELD_B and where
TABLE_A.FIELD_ID = '0001';
Anything?
-- Peace, James Wj Snyder Wells Fargo BankReceived on Mon Nov 03 1997 - 00:00:00 CET