Re: Group Syntax Error - not properly ended

From: Scott <me_at_yahoo.com>
Date: Thu, 09 Aug 2001 11:08:00 GMT
Message-ID: <3b726f61.507202508@news.mn.mediaone.net>

On 8 Aug 2001 16:33:56 -0700, Thomas Kyte <tkyte_at_us.oracle.com> wrote:

>In article <3b71b491.28162145_at_news.onvoy.com>, scott_at_yahoo.com says...
>>
>>When I save this view, I get the error message "ORA-00933:
>>SQL command not properly ended.". What do you think is
>>wrong? I am running on Oracle 7. Below is the text in the view that
>>is failing.
>>
>>Thank You!!
>>Scott
>>
>>
>>SELECT
>> ARINVT.ITEMNO,
>> ARINVT.REV,
>> DAY_HRS.WORKORDER_ID,
>> Sum(IQMS_DAY_USE.TOT_MAT_QTY) SumOfQty
>>
>>FROM
>> DAY_USE,
>> DAY_PTS,
>> DAY_HRS,
>> ARINVT
>>
>>WHERE
>> DAY_USE.DAY_PTS_ID = DAY_PTS.ID, <<<<=====
>> AND DAY_PTS.DAY_HRS_ID = DAY_HRS.ID, <<<<------
>> AND DAY_USE.ARINVT_ID = ARINVT.ID
>>
>>GROUP BY ARINVT.ITEMNO, ARINVT.REV, DAY_HRS.WORKORDER
>>
>>
>>
>
>commas are not used in the predicate like that
>
>--
>Thomas Kyte (tkyte@us.oracle.com) http://asktom.oracle.com/
>Expert one on one Oracle, programming techniques and solutions for Oracle.
>http://www.amazon.com/exec/obidos/ASIN/1861004826/
>Opinions are mine and do not necessarily reflect those of Oracle Corp
>

Thank You!!
Scott Received on Thu Aug 09 2001 - 06:08:00 CDT