MySQL Forums
Forum List  »  Newbie

Re: MySQL LEFT JOIN problem.
Posted by: Harsha Chaithanya Kethepalle
Date: August 24, 2004 01:29AM

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'

Hope this helps you.

Options: ReplyQuote

Written By
August 23, 2004 12:31PM
August 24, 2004 06:14AM
Re: MySQL LEFT JOIN problem.
August 24, 2004 01:29AM
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.