I am tring to use this tsql query in a sql 2005 report it keeps giving me the error below. This query works in my ms sql 2000 ok but I keep getting this error in the 2005. Can some one look at this and tell me what I am doing wrong. Thank you.
There is an error in the query. Incorrect syntax near '('.
SELECT
DISTINCT
JOB.JOBID,
JOB.*,
PAYER.PAY_COMPANY,
PATIENT.SSN,
PATIENT.LASTNAME,
PATIENT.FIRSTNAME,
PATIENT.MIDDLENAME,
PATIENT.AM_PHONE,
PATIENT.EMAIL,
JOB_OUTCOME.DESCRIPTION AS 'JOB_OUTCOME_DESC'
FROM
(((((JOB LEFT JOIN PATIENT ON JOB.PATIENTID = PATIENT.PATIENTID)
( LEFT JOIN PAYER ON JOB.PAYERID = PAYER.PAYERID)
( LEFT JOIN REFERRAL_SOURCE AS ADJUSTER ON JOB.ADJUSTER.REFERRAL_ID)
( LEFT JOIN REFERRAL_SOURCE AS CM ON JOB.CASEMANAGERID = CM.REFERRAL_ID)
( LEFT JOIN JOB_OUTCOME ON JOB.JOBOUTCOMEID = JOB_OUTCOME_ID)
WHERE
(JOB.APPT_DATE BETWEEN @STARTDATE AND @ENDDATE)
AND (JOB.TRANSPORTATION = '1')
AND (AREACOORDINATOR = '138')
ORDER BY
JOB.APPT_DATE DESC;