D. Richard Hipp <[EMAIL PROTECTED]> wrote: > CREATE TABLE t1(a INTEGER, b INTEGER); > INSERT INTO t1 VALUES(1,2); > INSERT INTO t1 VALUES(9,8);
MSSQL Server 2000 > SELECT a AS b, b AS a FROM t1 ORDER BY a; b a ----------- ----------- 1 2 9 8 > SELECT b AS a, a AS b FROM t1 ORDER BY a; a b ----------- ----------- 2 1 8 9 > SELECT a, b AS a FROM t1 ORDER BY a; a a ----------- ----------- 1 2 9 8 > SELECT a AS x, b AS x ORDER BY x; Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'b'. > SELECT a AS b, b AS a WHERE a=1; Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'b'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. > SELECT a AS b, b AS a WHERE a=2; Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'b'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. > SELECT a AS x, b AS x WHERE x=1; Msg 207, Level 16, State 3, Line 1 Invalid column name 'a'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'b'. Msg 207, Level 16, State 3, Line 1 Invalid column name 'x'. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users