Heres the poop.
Table 1 has ID and page: but only contains 1 rec per ID, initial hit into the site
Table 2 has ID and page: multi recs per ID as they travel through the site
each table also has a time stamp.
I want to get total page views per day by page, when I join the 2 tables the counts are wrong and I can't get a total per page.
Here is what I had:
select a.page as apage,
b.page as bpage,
count(a.id) as acnt,
count(b.id) as bcnt
from table1 as a, table2 as b
where a.id = b.id
group by date, apage
order by date desc, acnt desc, apage
The problem is that acnt is over stated by a huge amount. Also, how can I total acnt and bcnt within the query.
Ned
