sql关联修改

UPDATE  p  set p.ClientID = c.id 
from PaymentTable p left JOIN ClientTable c on p.ClientID = c.ClientID
posted @ 2015-04-21 12:50  菜鸟@学习园地  阅读(1216)  评论(0)    收藏  举报