Re: Why is this an SQL syntax error?

_______________________________________________________________ This message and any attachments are intended for the individual or entity named above. If you are not the intended recipient, please do not read, copy, use or disclose this communication to others; also please notify the sender by replying to this message, and then delete it from your system. Thank you. _______________________________________________________________ It would appear that you can't group by rowid. Could this be because rowid's do not exist by default in fragmented tables? Anybody? I couldn't find it documented anywhere. strangiato@my-deja.com on 05/02/2000 01:39:11 PM Extension: To: informix-list@iiug.org cc: (bcc: Colleen M. Morrow/JonesDay) Subject: Re: Why is this an SQL syntax error? 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 groupby > > 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 ?? > > -- > John Carlson > Informix DBA > WHSmith USA > > #include std_disclaimer.h /* These are my opinions, not my company's > opinion */ > Sent via Deja.com http://www.deja.com/ Before you buy.