ahh was wondering why it wasnt working. How could I fix this? Do i need to use UNION ALL or something to return both query results?
–
user1022585Jan 5 '12 at 0:56

You can use the results from the 2nd row in PHP, can't you?
–
ypercubeJan 5 '12 at 1:00

Well before this inner join query I had 2 seperate queries instead and it worked, but with this new query it's not doing what it should do. Its not returning the correct mailcount
–
user1022585Jan 5 '12 at 1:01

There is another potential issue. What do you intend the date columns to show? You are actually grouping all the rows and counting them. There are probably many different dates there. Which one should be shown?
–
ypercubeJan 5 '12 at 1:08

thank you this works perfect, never heard of a cross JOIN
–
user1022585Jan 5 '12 at 1:22