Forum Discussion
Query acting as an AND
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 i...
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.