Re: MySQL LEFT JOIN problem.

[Harsha Chaithanya Kethepalle]

SELECT
concat(associates.lastname,', ',associates.firstname) as Operator,
mrdaily.kronoshours as Hours,
mrdaily.pto as PTO,
mrcategories.category as Category,
mrentries.quantity as quantity,
mrentries.pages as pages,
mrentries.orders as orders,
mrentries.hours as hours,
round(mrentries.quantity/mrentries.hours,2) as 'Qty PPH',
round(mrentries.pages/mrentries.hours,2) as 'Pages PPH',
round(mrentries.orders/mrentries.hours,2) as 'Orders PPH'
FROM mrentries t1
left join mrdaily t2 on t1.iddaily = t2.id
left join associates t3 on t2.idassociates = t3.id
left join mrcategories t4 on t1.categorie = t4.id
where entrydate='2004-08-03'

Hope this helps you.
Harsha.