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.