Re: left join with sum and group by

[Rick James]

Or, maybe I did not do the JOIN right...

SELECT a.date, a.weekday, a.workinghours,
       e.employee,
       sum(b.hours),
       sum(b.hours) - a.workinghours
    FROM a
    JOIN ( SELECT DISTINCT employee FROM b ) AS e
    LEFT JOIN b  ON a.date = b.date
                AND e.employee = b.employee   -- added this
    GROUP BY  a.date, e.employee