Oracle AS keyword and subqueries
The pattern for the SQL 99 ANSI is that the table can have an alias WITHOUT the AS keyword so, you can take out AS and it should work on every RDBMS. See it on fiddle:
In ISO/IEC 9075-2:1999, section 7.6 <table reference>, page 232:
<table reference> ::= <table primary> | <joined table><table primary> ::= <table or query name> [ [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] ] | <derived table> [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] | <lateral derived table> [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] | <collection derived table> [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] | <only spec> [ [ AS ] <correlation name> [ <left paren> <derived column list> <right paren> ] ] | <left paren> <joined table> <right paren>Also confirmed to work:
- MS Access (Jet)