Two Table columns into one Query

Question

I'm trying to bring data from two different columns into one query field. Example: Table1 [Field1] and [Field2]. I don't know if that's possible but in my Query I'm trying to bring the datas from these two Fields and show into one in Query. e.g.

|Table|

|DepartureDate1 | DepartureDate2|

| 15 Nov 2021 | 20 Nov 2021 |

|Query|

|DepartureDate1&2|

15 Nov 2021

20 Nov 2021

Thank you in advance.

Answer 1

Try using a UNION.

SELECT DepartureDate1 AS [DepartureDate] FROM Table1
UNION
SELECT DepartureDate2 AS [DepartureDate] FROM Table1