Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Join Update Query?!!!
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 CST
![]() |
![]() |