Hi all,
Please could you assist in the error I receive for number of columns in 2 selected queries of union query do not match
Please could you assist in the error I receive for number of columns in 2 selected queries of union query do not match
SELECT [Registration], [Order], [Opr# short text], [Purchase Req#]
FROM [Outstanding Items - IW49]
WHERE ((([IW49 Local TBL].[Registration])="ZT-HZA") AND (([IW49 Local TBL].[Order])="85391") AND (([IW49 Local TBL].[Control key])="ZA02"))
Union
Select [Registration], [Order],[Short Text]
From [Outstanding Items - ME2J]
WHERE ((([ME2J Local TBL].Registration)="ZT-HZA") AND (([ME2J Local TBL].Order)="85391"));