pietlinden - Monday, February 12, 2018 7:52 AM

That looks more like the underlying table is set up wrong. Either that or your example is misleading.
If your table is set up wrong, a query like this might fix it:
SELECT A, C
FROM Src
UNION ALL
SELECT B, D
FROM Src