|
View previous topic :: View next topic
|
| Author |
Message |
chandracdac
New User
Joined: 15 Jun 2007
Posts: 92
Location: bangalore
|
|
|
|
Hai
I have a ssmall question. I have 2 tables which are identical. but in my second table some fields are empty .so i have to compare the two tables and
i have to copy the fields from 1st table to second one where ever the fields are empty .can u try? and pls tell me. |
|
| Back to top |
|
 |
saiprasadh
Active User
Joined: 20 Sep 2006
Posts: 154
Location: US
|
|
|
|
Hi Chandra,
Try this query
| Code: |
UPDATE Table1 A
SET A.Column1 = (SELECT B.Column1 FROM
Table B WHERE
A.PrimarykeyColumn =B. PrimarykeyColumn)
WHERE
A.Column1 = ' ' |
Let me know if this works
Thanks
Sai |
|
| Back to top |
|
|
|
|
