Aliases

[Chris Boget]

If you can do this:

SELECT
  table_a_alias.col_name
FROM 
  table_a table_a_alias;

Why can't you do this:

SELECT
  1 AS A,
  A + 1 AS B,
  B + 1 AS C;

Why can't you use column aliases later in the select?  When 
you can use table aliases even before they are defined.

thnx,
Chris

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]