-
Hi,
we are trying to copy 2 columns from one table to another. we were trying to use update statement to achieve this task, but we are not able to find correct syntax.
eg:
table 1 table2
key1 key2
col1 colA
col2 colB
We would like to update table1 with values of colA & colB from table2 where key1 is equal to key2. Any help on this query is appericated.
thank you
Radhakrishnan.M
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|