Just found out that Oracle does not like it when you use the AS
keyword to alias a subquery:
SELECT * FROM (SELECT * FROM products) AS p
I need to keep my SQL queries as portable as possible. Will the removal of the AS
keyword in the above query affect any other RDBMS?