I am trying to combine the results of two queries into a new query. The problem I am having is that the two queries don't have the same IDs for the data.
Example: Query 1 has IDs 1, 2, 4, 5 and Query 2 has IDs 1, 2, 3, 5 Each ID has a count value associated with it.
I can't use a simple join query because Query 1 has IDs that Query 2 does not (4) and Query 2 has IDs that Query 1 does not (3). I can get three different results right now: IDs 1, 2, 5 or IDs 1, 2, 4, 5 or IDs 1, 2, 3, 5. I want to have results for IDs 1, 2, 3, 4, 5.
How can I get the new query to use all of the IDs, not just the ones that Queries 1 and 2 have in common, just Query 1's or just Query 2's?
Thanks!!!!