Union Qury

[Simon]

I have the following Union Query but it does not work, If i remove one
of the qrys it works fine,

How do i do a union query for 3 or more bits of data

Thannks

SELECT qryHotTubsWS.[IDNumber] AS IDNumber,
qryHotTubsWS.[ProductName] AS ProductName,
qryHotTubsWS.[Price] AS Price,
qryHotTubsWS.[ProductCode] As ProductCode,
'qryHotTubsWS' AS TheType
FROM qryHotTubsWS

UNION ALL SELECT qryExtrasWS.[IDNumber] AS IDNumber,
qryExtrasWS.[ProductName] AS ProductName,
qryExtrasWS.[Price] AS Price,
qryExtrasWS.[ProductCode] AS ProductCode,
'qryExtrasWS' AS TheType
FROM qryExtrasWS


UNION ALL SELECT qryProductsWS.[IDNumber] AS IDNumber,
qryProductsWS.[ProductName] AS ProductName,
qryProductsWS.[Price] AS Price,
qryProductsWS.[ProductCode] AS ProductCode,
'qryProductWS' AS TheType
FROM qryProductsWS



ORDER BY IDNumber;

 

[KARL DEWEY]

Try removing the ORDER BY IDNumber in your SQL.