Left Join problem
from:

Hello.
I have two counters, one for units, one for waste.
I need to pull the sum of the timers and separate by Year.
The Left Join kinda works to get the combined, but as soon as I put a where condition to separate the timers, the think falls apart.
Could someone please check this out and give point me in the right direction?
Thanks.
Jamie.

SELECT year(counts.ts) as SalesYear, Q1.Res1 AS units, Q2.Res2 as rate
FROM
(counts
LEFT JOIN (SELECT (counts.ts), SUM(counts.count) AS Res1
FROM...

Left Join problem

Poster :
Jamie T