Group Error

From: Scott <scott_at_yahoo.com>
Date: Thu, 19 Jul 2001 16:28:08 GMT
Message-ID: <3b570874.8036505@news.onvoy.com>

When I try to save this view, I get the error message "ORA-01730: invalid number of column names specified.". What do you think is wrong. I am running on Oracle 7. Below is the text in the view that is failing. I also pasted the sql from Access that works.

Sometimes it helps when someone else looks at it.

Thank You!!
Scott

Oracle 7 view that is failing:

SELECT

     FGMULTI.ARINVT_ID, 
     LOCATIONS.LOC_DESC,
     Sum(FGMULTI.ONHAND) AS SumOfONHAND

FROM 
     FGMULTI,
     LOCATIONS

WHERE
     FGMULTI.LOC_ID = LOCATIONS.ID

GROUP BY FGMULTI.ARINVT_ID,LOCATIONS.LOC_DESC Access sql that works:

SELECT FGMULTI.ARINVT_ID, LOCATIONS.LOC_DESC, Sum(FGMULTI.ONHAND) AS SumOfONHAND
FROM FGMULTI LEFT JOIN LOCATIONS ON FGMULTI.LOC_ID = LOCATIONS.ID GROUP BY FGMULTI.ARINVT_ID, LOCATIONS.LOC_DESC ORDER BY FGMULTI.ARINVT_ID, LOCATIONS.LOC_DESC; Received on Thu Jul 19 2001 - 11:28:08 CDT