DISTINCT on a Union All query?

[Robeen]

Hi,



I have a UNION ALL query that pulls Distinct [Name] from 6 different tables and sorts by Name.

When I run the query - there are multiple instances of most names.

Since I need a list that has NO duplicate Names - I did a 'Select Distnict [Name] . . . ' on my Union query & I got my list of Unique Names.

My question is - do I have to do this in two steps like I am - or is there a way for me to make this happen in my original UNION ALL query?

Thanks!

Robin

[pbaldy]

Try dropping the ALL. UNION by default will eliminate duplicates; adding ALL overrides that.

[Robeen]

Thanks, Paul.

Dropping the ALL from my UNION ALL in the query took out the dupes just like you said it would.

Appreciate it.
Robin

[pbaldy]

Happy to help Robin.