RE: Why is this an SQL syntax error?

strangiato@my-deja.com wrote: > > It's a column name. I suspect there is a problem with the rowid?? > > In article <390F01AD.30A7E5DD@bellsouth.net>, > "Carlson@WHSmith" <carlson1@bellsouth.net> wrote: > > strangiato@my-deja.com wrote: > > > > > > Informix 7.x > > > > > > select p_name,rowid,max(finish_dt) from p_status where id=10 group> by > > > 1,2 > > > > > > gives rise to a syntax error > > > > > > why? > > > > > > Sent via Deja.com http://www.deja.com/ > > > Before you buy. > > > > Is p_name a column name or a program variable ?? > > >Got it . . . . > >According to the manual, you can't use ROWID in the select list of a >query that contains an aggregate function. I believe that MAX() >qualifies. Why do you need the MAX if rowid is in there? or am I missing something as usual Paul Watson # WFSoftware Ltd # Things Are Going to Tel: +44 1436 674729 # Get a Lot Worse Fax: +44 1436 678693 # Before Things Get Worse www.wfsoftware.com/informix #