How do I create a select statement with an outerjoin on access queries?
Posted on 2008-06-25
I have an asp page that queries an access query. I now need to join the query results from one query with those from another query in the same db. My question is how do I outer join vwResults8.Team on vwResults2.Team. My existing select statement is:
SELECT Team, SUM(EffectiveRevenueReal) AS Rev From vwResults2 GROUP BY Team Order By SUM(EffectiveRevenueReal) DESC
I'd like to select all fields from vwResults8 and join on vwResults8.Team