Oracleism: Don't use AS for table aliases

In both MySQL and PostgreSQL, when giving tables aliases in the FROM clause, it is optional to use the AS keyword.

SELECT n.nid, u.uid, FROM {node} AS n LEFT JOIN {user} AS u ON n.uid = u.uid;

However, the Oracle database does not allow AS to be use in FROM or any JOINs.

SELECT n.nid, u.uid, FROM {node} n LEFT JOIN {user} u ON n.uid = u.uid;

Unfortunately, this makes finding the right alias for a table rather difficult.

Subscribe with RSS Subscribe to RSS - Oracle