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
 
Top