• To build on Lynn's point, if you don't have data for the second query, you can put in blank scalars like this:

    select

    SabtHazineID,

    SabtHazine.HazineID,

    EndUserNAme,

    Tedad,

    sabtHazineDate,

    Describtion

    from

    dbo.SabtHazine

    left JOIN dbo.Hazine

    ON dbo.Hazine.HazineID = dbo.SabtHazine.HazineID

    union all

    select

    Hazine.HazineName,

    Hazine.Mablagh,

    '',

    '',

    '',

    '',

    from

    AgencyDB.dbo.Hazine

    where

    HazineID not in (select HazineID from dbo.Hazine);