compubasic - 3:59 pm on Sep 15, 2010 (gmt 0)

Can you please reformat my query to show me how it should be done. I have just tried and am now receiving this general error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE joblog.joblogClientID=$clientID AND billingclasses.billingclassesID=joblog' at line 1


New query:

SELECT joblog.joblogJobID, joblog.joblogPerformedOn, joblog.joblogWorkDescription, joblog.joblogTime, joblog.joblogTravelCost, joblog.joblogLaborCost, joblog.joblogJobTotal, joblog.joblogOfficeID, billingclasses.billingclassesType, users.userName FROM joblog, billingclasses, users LEFT JOIN clientlocations ON clientlocations.clientlocationsOffice WHERE clientlocations.clientlocationsOfficeID=joblog.joblogOfficeID WHERE joblog.joblogClientID=$clientID AND billingclasses.billingclassesID=joblog.joblogBillingClass AND users.userID=joblog.joblogEngineerID