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)