var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Outer Join
Forgive me if this is dumb!
If there a way to get a join to give the results two tables without a commonality.
For example - I have a tables with data for each month. If I bring into a query two tables and want to get all the data with all store numbers. So a store might only be in one table not both.
My boss thought this would be an outer join. I said no. That is not possible because the tables need to be linked and then you will only get an outer join of one table. Have I missed something?
I hope this makes sense to someone and can give me an explanation.
Thanks . . .
Try a selection union query...
I think thats possible in your case.
You want a union query. See the help files.
This example will combine the data from Table1 and Table2.
SELECT Month, Sum([Value]) AS SumOfValue
(SELECT Table1.Month, Table1.Value
SELECT Table2.Month, Table2.Value
GROUP BY Month;