Re: Group Syntax Error - not properly ended

As far as I know SQL there are wrong commas in the where clause of your command.
I guess there should be ANDs.

WHERE

     DAY_USE.DAY_PTS_ID = DAY_PTS.ID AND -- *****
     AND DAY_PTS.DAY_HRS_ID = DAY_HRS.ID AND -- ****
     AND DAY_USE.ARINVT_ID =  ARINVT.ID

Scott wrote:

>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
>
>
>

-- 
Mgr. Stanislav Opichal
PIKE Electronic
Karoliny Svetle 2
779 00

e-mail: SOpichal_at_pikeelectronic.com
tel: +420 (0)68 57 57 147
fax: +420 (0)68 57 57 140