Re: Group Syntax Error - not properly ended

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