MySQL Forums
Forum List  »  Newbie

Re: MySQL LEFT JOIN problem.
Posted by: Scott Hamm
Date: August 24, 2004 06:11AM

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 =
-> left join associates t3 on t2.idassociates =
-> left join mrcategories t4 on t1.categorie =
-> where entrydate='2004-08-03' ;
ERROR 1109 (42S02): Unknown table 'associates' in field list

Options: ReplyQuote

Written By
August 23, 2004 12:31PM
August 24, 2004 06:14AM
Re: MySQL LEFT JOIN problem.
August 24, 2004 06:11AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.