• i write this query but it give me this error:

    All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in their target lists.

    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)