Union Query Column mismatch (1 Viewer)

[Gismo]

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

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"));

 

[arnelgp]

you are missing "purchase req#" on your Union.
union query must have same number of columns.

 

[Gismo]

I dont have purchase requisition on the union, only on the first section

I need to see all order numbers for both and the requisition number on the first
On the second part I only have a text

 

[arnelgp]

you need to provide it by "faking" it:

...
...
Union

Select [Registration], [Order],[Short Text], "" As [Purchase Req#]
From [Outstanding Items - ME2J]
WHERE ((([ME2J Local TBL].Registration)="ZT-HZA") AND (([ME2J Local TBL].Order)="85391"));

 

[Gismo]

Works like a charm, thank you