MySQL: mysql> SELECT a AS b, b AS a FROM t1 ORDER BY a; +------+------+ | b | a | +------+------+ | 1 | 2 | | 9 | 8 | +------+------+ 2 rows in set (0.00 sec)
mysql> SELECT b AS a, a AS b FROM t1 ORDER BY a; +------+------+ | a | b | +------+------+ | 2 | 1 | | 8 | 9 | +------+------+ 2 rows in set (0.00 sec) mysql> SELECT a, b AS a FROM t1 ORDER BY a; ERROR 1052 (23000): Column 'a' in order clause is ambiguous mysql> SELECT a AS x, b AS x ORDER BY x; ERROR 1054 (42S22): Unknown column 'a' in 'field list' mysql> SELECT a AS b, b AS a WHERE a=1; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE a=1' at line 1 mysql> SELECT a AS b, b AS a WHERE a=2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE a=2' at line 1 mysql> SELECT a AS x, b AS x WHERE x=1; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE x=1' at line 1 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users