Prevent Duplicates from Union Query

#1 (**permalink**) 28-Jul-2006, 08:15 AM

I have a simple Union Query, but it returns duplicates from my 2 tables. I am
using just the Union Select not Union All Select. Is there an easy way to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10733-prevent-duplicates-from-union-query.html
prevent the duplicates?

SQL:

Select Customerreffullname as customer, RequestDate as
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10733
RequestDateorNumberofDayssincelastpickup, RequestType
from qrypickuprequestMMCO

UNION select Customer, Dayssincelastpickup as
RequestDateorNumberofDayssincelastpickup, RequestType
from qryMutualInvoiceOrderLineLastPickupPastDeadline;

*

#2 (**permalink**) 28-Jul-2006, 08:15 AM

You could do SELECT DISTINCT * FROM YourUnionQuery...
--
hth,
SusanV

"PPCO" wrote in message
news:C4E358FA-B82E-4DC4-AC38-720112A0818A@microsoft.com...
>I have a simple Union Query, but it returns duplicates from my 2 tables. I
>am
> using just the Union Select not Union All Select. Is there an easy way to
> prevent the duplicates?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10733
>
> SQL:
>
> Select Customerreffullname as customer, RequestDate as
> RequestDateorNumberofDayssincelastpickup, RequestType
> from qrypickuprequestMMCO
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10733
>
> UNION select Customer, Dayssincelastpickup as
> RequestDateorNumberofDayssincelastpickup, RequestType
> from qryMutualInvoiceOrderLineLastPickupPastDeadline;
>
>

#3 (**permalink**) 28-Jul-2006, 08:15 AM

A UNION query can not return duplicate records. Something in the record MUST
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10733
be different for them to be returned. So you need to define what you consider
a duplicate. Is it one field or a combination of more than one field? Which
fields?
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"PPCO" wrote:

> I have a simple Union Query, but it returns duplicates from my 2 tables. I am
> using just the Union Select not Union All Select. Is there an easy way to
> prevent the duplicates?
>
> SQL:
>
> Select Customerreffullname as customer, RequestDate as
> RequestDateorNumberofDayssincelastpickup, RequestType
> from qrypickuprequestMMCO
>
> UNION select Customer, Dayssincelastpickup as
> RequestDateorNumberofDayssincelastpickup, RequestType
> from qryMutualInvoiceOrderLineLastPickupPastDeadline;
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10733
>
>