Re: Columns alias ?

[Rick Pasotto <rick@xxxxxxxx>]

On Mon, Jan 01, 2001 at 03:02:38PM -0500, Bob Hall wrote:
> >How can I make this work ?
> >
> >SELECT a_very_very_long_function_to_repeate_in_where_clausule(parm1,parm2)
> >as short_form WHERE short_form<=2 ;
> >
> >This syntaxe produces a error, so what is the correct form to alias one
> >colum with a long name that we use on WHERE ?
> 
> Sir, you need a FROM clause.

The DuBois book explicity states that column aliases are not allowed in
WHERE clauses.

-- 
"Freedom is just chaos with better lighting."
		-- Alan Dean Foster
		   Rick Pasotto email: rickp@xxxxxxxxxxxx

-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60333@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php