Re: Select statement question

From: "Ira Rosen" <irosen1@email.mot.com> > >Is there some way with Informix to execute a select statement containing an >order by clause with 1 column such that the column in the order by clause >does not need to be output by the select statement? In other words, I want >to order output based on a column, but I don't want to see the content in >my >output. I didn't see any obvious ways looking at the select syntax in the >Informix Guide to SQL Syntax document. I've worked with other databases >that >have this functionality, so I'd expect Informix to offer this functionality >as well. And which databases were these? In a nutshell, it's an ANSI requirement that something you order by is in the select list, so, no. _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.