Oracle does not support table alias with the as. For example: SQL> select 1 2 from dual as a; from dual as a * ERROR at line 2: ORA-00933: SQL command not properly ended SQL> select 1 2 from dual a; 1 ———- 1 The same way: SQL> select * 2 from ( 3 select … Read more
oracle does not support as for table aliases, only for column aliases and they are optional for that use => delete all as keywords 😉
Just remove the AS keyword select P.carrier_id, O.order_id, O.aircraft_id, O.quantity from orderline O inner join purchaseorder P on O.order_id = P.carrier_id;
There are two reasons for using table aliases. The first is cosmetic. The statements are easier to write, and perhaps also easier to read when table aliases are used. The second is more substantive. If a table appears more than once in the FROM clause, you need table aliases in order to keep them distinct. … Read more
You can use AS for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it’s always optional and on Oracle it’s illegal. So remove the AS : SELECT G.Guest_ID, G.First_Name, G.Last_Name FROM Guest G