SQL Level Clause error message

Hi,

Try removing semi-colon at the end of FROM clause , like this

SELECT tblDriver.DriverID, tblJobDetail.JobID, [SUM(tblJobOrder.DistanceEst)] AS [Sum of Distance Estimate]
FROM tblJobOrder 
INNER JOIN (tblDriver INNER JOIN tblJobDetail ON tblDriver.DriverID = tblJobDetail.DriverID) ON tblJobOrder.JobID = tblJobDetail.JobID
GROUP BY tblDriver.DriverID

---

sathya - www.allaboutmssql.com ** Mark as answered if my post solved your problem and Vote as helpful if my post was useful **.