在table1里面加一个字段OAID,如果packId相同,将table2里面的OAID同步到table1
Update a
set a.OAID =b.OAID
from
table1 a inner join
table2 b
on a.PackID = b.PackID
在table1里面加一个字段OAID,如果packId相同,将table2里面的OAID同步到table1
Update a
set a.OAID =b.OAID
from
table1 a inner join
table2 b
on a.PackID = b.PackID
转载于:https://www.cnblogs.com/meguoling/archive/2012/07/10/2585127.html