I am currently using 2 queries to get recordsets from a database as follows:
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
Bookmarks