union query duplicates

  • Thread starter Thread starter mkm
  • Start date Start date
M

mkm

Is there a way to eliminate duplicates in a union query?
Like distinctrow or something like that? Thanks!
 
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 SELECT 5
Duplicates in union query 3
Union query producing duplicate records 7
merging 2 queries 3
Union Query to list duplicates 2
Union Query, duplicates 1
Duplicates in Union Query 2
Losing Records Between Union Query and Select Query 3

Back
Top