HI..
Can anyone please help me with this Error. Incorrect syntax near the keyword 'inner'.
Query is:
SELECT iCalls_Calls.CALL_ID,C.CALL_ID, iCalls_Calls.REQUESTOR, iCalls_Users.USER_NAME, DESCRIPTION, TYPE, SCOPE, SEVERITY, CAST(E.COUNT1/F.COUNT2 AS VarChar(5)), iCalls_Calls.STATUS_ID, iCalls_Status.STATUS_ID, iCalls_Status.STATUS_LABEL FROM iCalls_Calls C INNER JOIN(SELECT CALL_ID,COUNT(CALL_ID)AS COUNT1 FROM iCalls_Events GROUP BY CALL_ID) E ON C.CALL_ID=E.CALL_ID INNER JOIN(SELECT CALL_ID,COUNT(CALL_ID)AS COUNT2 FROM iCalls_Events WHERE EVENTS_FLAG <> 0 GROUP BY CALL_ID ) F ON C.CALL_ID=F.CALL_ID ((iCalls_Calls inner join iCalls_Status on iCalls_Calls.STATUS_ID=iCalls_Status.STATUS_ID) inner Join iCalls_Users on iCalls_Calls.REQUESTOR=iCalls_Users.USER_ID) left outer join iCalls_Messages on iCalls_Calls.CALL_ID=iCalls_Messages.CALL_ID WHERE REQUESTOR='" & Session("USER_ID") & "' AND iCalls_Calls.STATUS_ID <> 6 ORDER BY iCalls_Calls.CALL_ID
Thanks a lot..
|
| Author: Jayaprakashbalraj 03 Sep 2007 | Member Level: Silver | Rating:  Points: 2 |
SELECT iCalls_Calls.CALL_ID,C.CALL_ID, iCalls_Calls.REQUESTOR, iCalls_Users.USER_NAME,
DESCRIPTION, TYPE, SCOPE, SEVERITY, CAST(E.COUNT1/F.COUNT2 AS VarChar(5)),
iCalls_Calls.STATUS_ID, iCalls_Status.STATUS_ID, iCalls_Status.STATUS_LABEL
FROM iCalls_Calls C INNER JOIN(SELECT CALL_ID,COUNT(CALL_ID)AS COUNT1
FROM iCalls_Events GROUP BY CALL_ID) E ON C.CALL_ID=E.CALL_ID
INNER JOIN(SELECT CALL_ID,COUNT(CALL_ID)AS COUNT2
FROM iCalls_Events WHERE EVENTS_FLAG <> 0 GROUP BY CALL_ID ) F
ON C.CALL_ID=F.CALL_ID
inner join iCalls_Status on (iCalls_Calls.STATUS_ID=iCalls_Status.STATUS_ID)
inner Join iCalls_Users on (iCalls_Calls.REQUESTOR=iCalls_Users.USER_ID)
left outer join iCalls_Messages on iCalls_Calls.CALL_ID=iCalls_Messages.CALL_ID
WHERE REQUESTOR='" & Session("USER_ID") & "' AND iCalls_Calls.STATUS_ID <> 6
ORDER BY iCalls_Calls.CALL_ID
just try this.......
|