update a set a.OrgId=b.OrgIdfrom [dbo].[Base_User] a left join [dbo].[Oil_Org] b on b.OrgCode=a.LoginAccount
易网时代-编程资源站