Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-16-2019, 06:25 AM   #1
sumdumgai
Newly Registered User
 
Join Date: Jul 2007
Posts: 384
Thanks: 132
Thanked 1 Time in 1 Post
sumdumgai is on a distinguished road
how to use a Union query to get distinct records

I have three identically designed tables. I do not want to combine rows with a Union or Union All. What is the query that would give me the distinct pairings of field1 and field2 for all three tables?


Thanks for your help.

sumdumgai is offline   Reply With Quote
Old 03-16-2019, 08:42 AM   #2
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,395
Thanks: 0
Thanked 340 Times in 339 Posts
June7 will become famous soon enough
Re: how to use a Union query to get distinct records

Sorry, use UNION.
__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
sumdumgai (03-17-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Union Query seems to have too few records David Ball Queries 4 01-26-2016 05:57 AM
[SOLVED] A query with Distinct against a SQL view with Distinct truncates string Rx_ SQL Server 2 05-05-2015 08:13 AM
250 million records in a union query Access9001 General 16 08-28-2011 05:06 PM
Help! Query to show distinct price records hardrock Queries 3 03-04-2009 07:41 AM
need distinct records of whle table but distinct on one field ukdata Queries 1 09-16-2006 11:22 PM




All times are GMT -8. The time now is 12:36 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World