|Subject:||Problem with Union query|
|Date:||Tue, 20 Aug 2019|
I have a query that is the Union of two other Select queries
Select * From StockItemsUsed UNION SELECT * From StockItemsSold ORDER BY DateFromStock DESC;
When I run the first (StockItemsUsed) on its own it includes some duplicate records. This is correct.
However when I run the Union query above, the duplicates do not appear but only a single occurrence of each.
Each of the queries StockItemsUsed and StockItemsSold have Unique values and Unique records set to No in the property sheet.
Can anyone please explain why the duplicates disappear in the Union. And how to preserve them