Larry,
Thanks Larry. At least you folks do not have to think much when I ask a question. I now understand the statement in the HELP. but any column not named in the GROUP BY clause can be used only in the command clause if the column is used in a SELECT function. That was my key. I just got lucky when I created the other views with the group by clause. Jim ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Saturday, January 16, 2010 10:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: create view << create temporary view tOrdShiptots (col names w/ commas) as select Control#, Model#, Outshipinv, SortOne, Quantity, SUM(ShipQty) from OrderShip + where clause w. group by clause. The error I get on this view is -ERROR- Illegal column specification (2512) >> Your group by clause must contain all of Control#, Model#, Outshipinv, SortOne, Quantity and probably doesn't. -- Larry
