<div>
select f1,f2 from A<br />
Union All<br />
select f1,f2 from A<br />
<br />
will give you duplicate values<br />
<br />
<br />
select f1,f2 from A<br />
Union<br />
select f1,f2 from A<br />
<br />
no duplicate values
</div>


select f1,f2 from A
Union All
select f1,f2 from A

will give you duplicate values


select f1,f2 from A
Union
select f1,f2 from A

no duplicate values

<div>
Thanks, I completely forgot about Union All
</div>


Thanks, I completely forgot about Union All

<div>
<div class="content wysiwyg-content">
Just as a curiosity, can you tell me why if I Union two identical MS Access Queries I don't get double the same results? Is there a particular reason why the union only works for combining queries that are different?
</div>
</div>


Just as a curiosity, can you tell me why if I Union two identical MS Access Queries I don't get double the same results? Is there a particular reason why the union only works for combining queries that are different?

Union query with identical queries

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.