Date: Fri, 31 Dec 2004 21:04:31 -0800 From: DA Morgan User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.theory Subject: Re: How to identify a column in order by clause References: <1104534959.058255.150190@z14g2000cwz.googlegroups.com> In-Reply-To: <1104534959.058255.150190@z14g2000cwz.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <41d62e41$1_4@127.0.0.1> Lines: 12 X-Comments: This message was posted through Newsfeeds.com X-Comments2: IMPORTANT: Newsfeeds.com does not condone, nor support, spam or any illegal or copyrighted postings. X-Comments3: IMPORTANT: Under NO circumstances will postings containing illegal or copyrighted material through this service be tolerated!! X-Report: Please report illegal or inappropriate use to X-Abuse-Info: Please be sure to forward a copy of ALL headers, INCLUDING the body (DO NOT SEND ATTACHMENTS) Organization: Newsfeed.com http://www.newsfeeds.com 100,000+ UNCENSORED Newsgroups. Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news-out.nntp.be!spool4-maxim!not-for-mail Xref: dp-news.maxwell.syr.edu comp.databases.theory:29248 todd_run wrote: > The question I have is: In a select statement that uses column > aliases, should the order by clause include the column name or the > column alias? Might depend on the product. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)