Fra
http://www.mysql.com/doc/en/SELECT.html :
The FROM table_references clause indicates the tables from which to retrieve rows. If you name more than one table, you are performing a join. For information on join syntax, see section 6.4.1.1 JOIN Syntax. For each table specified, you may optionally specify an alias.
table_name [[AS] alias] [USE INDEX (key_list)] [IGNORE INDEX (key_list)]
Eksempel:
A table reference may be aliased using tbl_name [AS] alias_name:
mysql> SELECT t1.name, t2.salary FROM employee AS t1, info AS t2
-> WHERE t1.name = t2.name;
mysql> SELECT t1.name, t2.salary FROM employee t1, info t2
-> WHERE t1.name = t2.name;
Så er der vist ikke tvivl om gyldigheden af at udelade 'AS' !