Solved Need to marge 2 queries while removing duplicates

tihmir

Registered User.
Local time
Yesterday, 21:26
Joined
May 1, 2018
Messages
257
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"
 
use union query - and be sure to structure it using the mere word UNION, not UNION ALL
 

Users who are viewing this thread

Back
Top Bottom