M mkm Apr 20, 2004 #1 Is there a way to eliminate duplicates in a union query? Like distinctrow or something like that? Thanks!
Is there a way to eliminate duplicates in a union query? Like distinctrow or something like that? Thanks!
G Gerald Stanley Apr 20, 2004 #2 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
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
