Re: MySQL LEFT JOIN problem.
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.