Query acting as an AND

[procyon82]

I have a query that gets sessions from Google analytics. The data goes back a few years.

We recently turned on demographics data in Google Analytics. If I now include demographics data in my query it acts as a filter and will only show me sessions data when there is data for demographics. Is there a way to make demographics data optional in the query? I.e. Get me all data even if certain rows don't have values for certain columns. 

My current workaround is to have two separate queries, but I was wondering if there is a way to get all data in a single query.

Thanks!

[CahabaData]

It really comes down to this phrase: " include demographics data in my query "

If this demographic data is in a separate table - then your join line is going to act like an AND in its default state of an inner join (where the join must match a value in both tables) - and you would need to option it to be an outer join where ALL data regardless of demographies....which should result in null/blanks for your records without demographies...

On the otherhand if it is not a separate table involving a join - then I'm not sure what is your query design as you should be able to add just another field of a single table without a problem.