union query duplicates

M

mkm

Is there a way to eliminate duplicates in a union query?
Like distinctrow or something like that? Thanks!
 
G

Gerald Stanley

You can use SELECT DISTINCT in each part of the union
query. For complete distinctness you can use
SELECT DISTINCT columnNames FROM
(Your Union Query SQL)

Hope This Helps
Gerald Stanley MCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union Query to list duplicates 2
Duplicates in union query 3
merging 2 queries 3
Duplicates in Union Query 2
Union Query, duplicates 1
UNION SELECT 5
Union Query 4
union query of complex queries 1

Top