Forum OpenACS Q&A: Response to Help with SQL error

Posted by Brian Fenton on
Hi Nick,
what is exactly you're trying to do here? It looks like you're trying to count the number of distinct users + browser for each date_id, for each n_sessions_day and for each member_p (which doesn't really make a lot of sense to me). Without knowing the nature of your data, it's hard for me to figure out what you need. Can you describe what each table column contains and maybe even give some example data?

I think maybe you can get around your problem with a few subqueries or even a clever UNION.