Data from two tables

[aftabn10]

I have 3 tables. 1 table of names, 1 table of Queue A results, 1 table of Queue B results. What i would like to do is run one query that will combine the table of names, and give me their set of results. For example:

Table of Names
Humpty
Dumpty
Mickey
Mouse

Queue A Results
Humpty | 2
Dumpty | 7
Mickey | 1
Mouse | 3

Queue B Results
Humpty | 3
Dumpty | 4
Mickey | 4
Mouse | 2

The above are my three tables and the following is what i would like to see after i run my query:

QUERY RESULTS
Humpty | 5
Dumpty | 11
Mickey | 5
Mouse | 5

If somebody could please help.

Thanks in advance.

 

[pbaldy]

You need a UNION query to join the two tables together, then a totals query based on that UNION query. You might be able do it with a join, but I think the UNION will be more flexible.