Duplicates don't show up in my Union Query

[Teri]

Below is the verbage on my union query. Everything works okay, except it suppresses a duplicate record if everything across the record is exactly the same. I don't want it to do that. Can someone please tell me if there is something I can add to this so that won't happen

Thanks!

SELECT [Master.Company],[Master.FirstName],[Master.LastName],[Master.Address],[Master.Address2],[Master.City],[Master.State],[Master.Zip
FROM [qry TW Subscribers (TW Comp and TW Paid Only)
UNION SELECT [Agency],[AgFirstName],[AgLastName],[AgAddress],[AgAddress2],[AgCity],[AgState],[AgZip
FROM [qry TW Subscribers (Agencies Only)]

 

[david epsom dot com dot au]

Use
UNION ALL
instead of
UNION

It also often runs much faster!

(david)

Below is the verbage on my union query. Everything works okay, except it

suppresses a duplicate record if everything across the record is exactly the
same. I don't want it to do that. Can someone please tell me if there is
something I can add to this so that won't happen?

Thanks!!

SELECT [Master.Company],[Master.FirstName],[Master.LastName],[Master.Address],[Mast
er.Address2],[Master.City],[Master.State],[Master.Zip]
FROM [qry TW Subscribers (TW Comp and TW Paid Only)]
UNION SELECT [Agency],[AgFirstName],[AgLastName],[AgAddress],[AgAddress2],[AgCity],[AgSta
te],[AgZip]
FROM [qry TW Subscribers (Agencies Only)];

 

[Teri]

THANKS so much for letting me know! I truly appreciate you taking the time to respond!!!!