SqlServer数据库中update关联修改

 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 所以未找到,修改失败,  修改关联方式之后 能够查找到,修改成功