Combining 2 queries with Distinct Fields

[Kyle123]

I am currently using 2 queries to get recordsets from a database as follows:

Please Login or Register  to view this content.

Which outputs the following:

FORCE_Completions	Name	Username
5	Kyle	Kyle123
5	James	James123

ICOMS_Completions	Name	Username
10	Kyle	Kyle123
5	Kevin	Kevin123

I would like to combine these into a single query with the following:

FORCE_Completions	ICOMS_Completions	Name	Username
5	10	Kyle	Kyle123
5	0	James	James123
0	5	Kevin	Kevin123

However a given user may appear in either query or both and I'm unsure how best to join the recordsets to get the output I would like

Although I've posted this in the Access forum, I'm using SQL Server (2005) as I think this a conceptual issue rather than a specific one to access.

Any help is much appreciated

[OnErrorGoto0]

Can you not do a SUM query based on a subquery that UNIONs those two queries?

[Kyle123]

yes, I was overthinking it

The following is the SQL I'm using:

Please Login or Register  to view this content.

[OnErrorGoto0]

yes, I was overthinking it

Luckily, I'm too simple to ever have that problem.

[Kyle123]

hehe that's usually what I say!!