Parry IT Support

SELECT [Product ID], [Order Date], [Company Name], [Transaction], [Quantity] FROM [Product Orders]
UNION
SELECT [Product ID], [Creation Date], [Company Name], [Transaction], [Quantity] FROM [Product Purchases]
ORDER BY [Order Date] DESC

Links

https://support.microsoft.com/en-us/office/use-a-union-query-to-combine-multiple-queries-into-a-single-result-1f772ec0-cc73-474d-ab10-ad0a75541c6e