• ok. i change query this way and it is work.is it optimize query??

    select

    BsH.SabtHazineId,

    BsH.HazineID,

    BsH.EndUserNAme,

    BsH.Tedad,

    BsH.sabtHazineDate,

    BsH.Describtion,

    Coalesce( BH.HazineName, H.HazineName ) as [HazineName],

    Coalesce( BH.Mablagh, H.Mablagh ) as [Mablagh]

    from AgencyBackupDB.dbo.SabtHazine as BSH

    left outer join AgencyBackupDB.dbo.Hazine as BH on BH.HazineID = BSH.HazineID

    left outer join dbo.Hazine as H on H.HazineID = BSH.HazineID