UPDATE a SET a.FColonyHouseName = b.FName, a.FFreeingStageName = NULL, a.FMonoidName = c.FName, a.FCostItemName = e.FName, a.FEarTagNumber = f.FEarTagNumber FROM #T_Result a LEFT JOIN dbo.T_Base_Org_BaseInfo b ON b.FOrgID = a.FColonyHouseID INNER JOIN dbo.T_Base_Proc_Monoid c ON c.FMonoidID = a.FMonoidID LEFT JOIN dbo.T_Base_Proc_FreeingStage d ON d.FFreeingStageID = a.FFreeingStageID INNER JOIN dbo.T_Base_FN_CostItem e ON e.FCostItemID = a.FCostItemID INNER JOIN dbo.T_Proc_Sow_OrgInfo f ON f.FPigID = a.FPigID;
记录:update失败,
原因:关联表中,有的数据为null 所以未找到,修改失败, 修改关联方式之后 能够查找到,修改成功
SqlServer数据库中update关联修改
最新推荐文章于 2024-03-27 13:48:06 发布