 |
MVSFORUMS.com A Community of and for MVS Professionals
|
Author |
Message |
Topic: update using join |
Manobabu
Replies: 1
Views: 821
|
Forum: Database Posted: Fri May 28, 2004 5:10 am Subject: update using join |
Hi,
Any body know whether we can update a table value directly from other table as like below query.
Update TABLE1 TABLE2
SET TABLE1.COLUMN1=TABLE2.COLUMN3
WHERE TABLE1.COLUMN2=TABLE2.COLUMN1 AN ... |
|
Page 1 of 1 |
All times are GMT - 5 Hours |
|