Re: [BUGS] Incorrect column identifer using AS in SELECT statement on a VIEW.

-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.0.1 20050727 (Red Hat 4.0.1-5) On 11/23/05, Hayden James <[EMAIL PROTECTED]> wrote: If I create a normal table and a normal view that queries that table I get incorrect results when I query the view using the AS alias in the select statement

[BUGS] Incorrect column identifer using AS in SELECT statement on a VIEW.

If I create a normal table and a normal view that queries that table I get incorrect results when I query the view using the AS alias in the select statement.  For example, if I create the following objects: CREATE TABLE Test1( col1 VARCHAR(200) ); CREATE VIEW Test2 AS SELECT col1 FROM Test1 ORDER