Aggregation script for uniting two transactional Excel tables (for POV)

Use the below script:


SELECT *FROM
(
SELECT
date, location, item_code, quantity_sold, sales_price_unit, on_hand FROM  [orderlist-1-transactions]
UNION ALL 
SELECT
date, location, item_code, quantity_sold, sales_price_unit, on_hand
FROM [orderlist-2-transactions]
)
ORDER BY date DESC