Hi,

MySQL 4.1

How would I incorporate this condition to my left join?
emp.emp_id = a_logs.emp_id AND emp.mgr_id = some_var


SELECT
*,
COUNT(AL0.id) AS Sunday,
COUNT(AL1.id) AS Monday,
COUNT(AL2.id) AS Tuesday,
COUNT(AL3.id) AS Wednesday,
COUNT(AL4.id) AS Thursday,
COUNT(AL5.id) AS Friday,
COUNT(AL6.id) AS Saturday,
item_name.Name AS Object, item_name.ID
FROM
item_name
LEFT JOIN
a_logs AS AL0 ON (AL0.Object = item_name.ID AND DATE_FORMAT(AL0.Date,'%w') = '0')
LEFT JOIN
a_logs AS AL1 ON (AL1.Object = item_name.ID AND DATE_FORMAT(AL1.Date,'%w') = '1')
LEFT JOIN
a_logs AS AL2 ON (AL2.Object = item_name.ID AND DATE_FORMAT(AL2.Date,'%w') = '2')
LEFT JOIN
a_logs AS AL3 ON (AL3.Object = item_name.ID AND DATE_FORMAT(AL3.Date,'%w') = '3')
LEFT JOIN
a_logs AS AL4 ON (AL4.Object = item_name.ID AND DATE_FORMAT(AL4.Date,'%w') = '4')
LEFT JOIN
a_logs AS AL5 ON (AL5.Object = item_name.ID AND DATE_FORMAT(AL5.Date,'%w') = '5')
LEFT JOIN
a_logs AS AL6 ON (AL6.Object = item_name.ID AND DATE_FORMAT(AL6.Date,'%w') = '6')
GROUP BY
item_name.Name
ORDER BY
item_name.Name ASC
The query above outputs:

s m t w t f s
row1 0 0 0 0 0 0 0
row2 0 0 1 0 0 1 0
row3 0 0 1 0 1 1 0
row4 0 0 0 0 0 0 0
row5 0 0 1 0 0 0 0
Any suggestions ?

Thanks