I am tracking banner clicks and views in 2 tables with the id of the banner and the date the view or click happened. I want to count the number of clicks and views in one query, because I'm lazy.

So this is what I tried:

SELECT COUNT(banner_views.*) AS `views`, COUNT(banner_clicks.*) AS `clicks` FROM banner_views,banner_clicks WHERE banner_views.bannerID='4' AND banner_clicks.bannerID='4';

I am gonna do it it 2 separate queries because I'm pretty sure it's the only way:

SELECT COUNT(*) AS `views` FROM banner_views WHERE banner_views.bannerID='4';

SELECT COUNT(*) AS `clicks` FROM banner_clicks WHERE banner_clicks.bannerID='4';

For future reference, is there another way to do this?

there is no reason to actually join these for a simple query on statistics, as there is no relation between the stats. Any attempt to join these two would just slow things down ... you are better off doing it as 2 seperate queries ... in my opinion.

I'm lazy, thats the only reason.

Thanks.