Just discovering Union queries. I’m trying to convert an Excel table, linked to my DB, into a normal Select query. I have been reading prior posts on this forum and have managed to get almost there. What I can’t work out is, how to include the column headers in the body of the query.
Code used
SELECT DailyClosePrices.Pricedate, DailyClosePrices AFI As ClosePrice
FROM DailyClosePrices
UNION
SELECT DailyClosePrices.Pricedate, DailyClosePrices ARG
FROM DailyClosePrices
UNION
SELECT DailyClosePrices.Pricedate, DailyClosePrices A200
FROM DailyClosePrices
Table and query samples attached, showing current results and required outcome. Any help would be much appreciated.
Table & Query samples (https://i.sstatic.net/3iRM0tlD.png)
RayH is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.