Explain THIS, please!

From: Bill Meahan <wwm_at_ef5003.efhd.ford.com>
Date: Fri, 18 Dec 1992 20:42:01 GMT
Message-ID: <1gtd91INN7ln_at_ef2007.efhd.ford.com>

I'm tearing my hair out at the following:

SQL> l
  1 select '%' Shift,
  2 p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code PartNumber,   3 s.scrap_code Reason,
  4 SUM(s.cost) TotalDollars
  5 FROM cimcmms.scrap_count_history s, acg.part p   6 WHERE s.part_key=p.key

  7    AND s.work_center_code = '75021'
  8    AND s.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
  9    AND s.shift LIKE '%'
 10    AND s.part_key IN ( SELECT ss.part_key
 11       FROM cimcmms.scrap_count_history ss
 12       WHERE ss.work_center_code = '75021'
 13        AND ss.production_date BETWEEN '1-Dec-92' AND '13-Dec-92'
 14        AND ss.shift LIKE '%'
 15        AND ROWID <11
 16       GROUP BY ss.part_key
 17       ORDER BY SUM(ss.cost) desc )

 18 GROUP BY '%',
 19 p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,  20 s.scrap_code
 21 ORDER BY p.prefix||'-'||p.base_code||'-'||p.suffix||p.control_code,  22* SUM(s.cost) desc

SQL> /

     ORDER BY SUM(ss.cost) desc )
     *

ERROR at line 17:
ORA-00907: missing right parenthesis

SQL> spool off

There certainly AREN'T any mismatched parentheses!

Any ideas what is going on?

The sqlplus version is 3.0.12.1.1
The ORACLE version is 6.0.36.1.1
Computer is HP 9000/867 HP-UX 8.0

-- 
Bill Meahan			|EFHD Information Systems Staff
Plant Floor Systems Specialist	|Ford Motor Company
wwm_at_ef5003.efhd.ford.com      	| +1 313 487 6122
..!fmsrl7!pmsmam!wwm           |I'm not paid to speak for Ford!

Received on Fri Dec 18 1992 - 21:42:01 CET