Re: problem with totals doubling when using a right join....

y" <[EMAIL PROTECTED]> com> Fax to: Subject: problem

problem with totals doubling when using a right join....

Hi All, I have a problem. I have 2 tables: mysql> SELECT int_traffic.day, sum(int_traffic.deliveries) as deliveries -> FROM int_traffic -> WHERE int_traffic.day between '2004-05-01' and '2004-05-31' -> GROUP BY int_traffic.day -> ORDER BY int_traffic.day; ++--