>
To: "Bill Easton" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, December 06, 2004 11:05 AM
Subject: Re: Yet another LEFT JOIN question
> > If you are using 4.1 or later, you could do a subquery to count the
> > clicks,
> > then left join that w
If you are using 4.1 or later, you could do a subquery to count the
clicks,
then left join that with the views.
I am using 4.1. I tried to do a sub-query, but never got it run. Can
you give me a quick example? Is the sub-query a better (faster) way to
do this?
Ron
On Dec 6, 2004, at 6:19 AM,
Try something like this
SELECT A1.ID,
SUM(IF(ISNULL(C.AdID),0,1)) AS Clicks,
SUM(IF(ISNULL(V.AdID),0,1)) AS Views
FROM Ads A1
LEFT JOIN Clicks C
ON A1.ID = C.AdID
LEFT JOIN Views V
ON A1.ID = V.AdID
GROUP BY A1.ID
-Original Message-
From: