ORA – 00933 confusion with inner join and “as”

I have this query of getting data from two tables using an inner join, but I get the error SQL command not properly ended with an asterix under “as”:

select P.carrier_id, O.order_id, O.aircraft_id, O.quantity

from orderline AS O

inner join purchaseorder AS P

on O.order_id = P.carrier_id;

the error:

from orderline AS O ( with an asterix under AS)


Error at line 2
Ora-00933: SQL command not properly ended.

In regards to this I thought that AS wouldn’t be an issue as it’s just referencing an alias, but I’m so confused as to why this is coming up.

Answer

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;