Solved Need to marge 2 queries while removing duplicates (1 Viewer)

tihmir

Registered User.
Local time
Yesterday, 21:56
Joined
May 1, 2018
Messages
216
Hi all, I need to marge 2 queries while removing duplicates
My first query "qry1" has 3 fields: "id", "name" "hm".
My second query "qry2" has the same fields as "qry1"
I need to marge these two queries while removing duplicate records in field "id"
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 12:56
Joined
May 7, 2009
Messages
16,393
use union query.
 

Isaac

Lifelong Learner
Local time
Yesterday, 21:56
Joined
Mar 14, 2017
Messages
6,454
use union query - and be sure to structure it using the mere word UNION, not UNION ALL
 

Users who are viewing this thread

Top Bottom