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

[tihmir]

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]

use union query.

 

[Isaac]

use union query - and be sure to structure it using the mere word UNION, not UNION ALL

 

[tihmir]

use union query.

use union query - and be sure to structure it using the mere word UNION, not UNION ALL

Thank you for your help. I appreciate it!