Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Group Syntax Error - not properly ended
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 Received on Wed Aug 08 2001 - 16:59:59 CDT