VVVV Urgent please [message #2425] |
Mon, 15 July 2002 10:52 |
Sreenath
Messages: 1 Registered: July 2002
|
Junior Member |
|
|
SELECT SLR_NAME,FMT_DESC,RTY_DESC FROM SLA_RESOURCE A,SLA_RESOURCE_FORMAT B,
SLA_RESOURCE_TYPE C WHERE A.rty_Id = 1 AND A.FMT_ID=B.FMT_ID AND
C.rty_Id = A.rty_Id AND A.SPT_ID IN (SELECT SPT_ID FROM SLA_PRD_TERM_REF WHERE
PRD_ID = 20 ORDER BY SPR_ICON_SORT_ORDER)
I get Error
PRD_ID = 20 ORDER BY SPR_ICON_SORT_ORDER)
*
ERROR at line 4:
ORA-00907: missing right parenthesis
Can anybody tell me what's wrong?
|
|
|
|