Problem with Union query

Giganews Newsgroups
Subject: Problem with Union query
Posted by:  internet.shoppi…@foobox.com
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

Replies