UPDATE p set p.ClientID = c.id from PaymentTable p left JOIN ClientTable c on p.ClientID = c.ClientID 转载于:https://www.cnblogs.com/hclw/p/4444067.html