Re: MySQL LEFT JOIN problem.

[Scott Hamm]

mysql> 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' ;
ERROR 1109 (42S02): Unknown table 'associates' in field list