Home » SQL & PL/SQL » SQL & PL/SQL » VVVV Urgent please
VVVV Urgent please [message #2425] Mon, 15 July 2002 10:52 Go to next message
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?
Re: VVVV Urgent please [message #2426 is a reply to message #2425] Mon, 15 July 2002 11:18 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Remove 'ORDER BY SPR_ICON_SORT_ORDER' from your query - an ORDER BY clause is not valid in a subquery.
Previous Topic: Re: Very urgent ... Help...!!!
Next Topic: Re: transfer sql results to temp table
Goto Forum:
  


Current Time: Mon Oct 21 19:49:48 CDT 2019