getting error in oracle 009933 sql command not properly ended

Question

here is my query by I didn't understand why it is not working.

  select o.MFR, o.PRODUCT, c.company, p.PRICE 
    from ORDERS AS o 
    inner join customers AS c on c.CUST_NUM = o.CUST
    inner join PRODUCTS AS p On p.MFR_ID = o.MFR 
    where o.CUST in ('2111','2112','2105','2119') and o.AMOUNT < '3000' 
    order by c.company DESC;

What's the data type of `o.AMOUNT`? – The Impaler Jul 07 '19 at 17:26 — The Impaler, Jul 07 '19 at 17:26
tried that too but not working – Sayed Mohd Ali Jul 07 '19 at 17:36 — Sayed Mohd Ali, Jul 07 '19 at 17:36

score 1 · Accepted Answer · answered Jul 07 '19 at 17:36

remove as from alias

select o.MFR, o.PRODUCT, c.company, p.PRICE 
from ORDERS  o 
inner join customers  c on c.CUST_NUM = o.CUST
inner join PRODUCTS  p On p.MFR_ID = o.MFR 
where o.CUST in ('2111','2112','2105','2119') and o.AMOUNT < '3000' 
order by c.company DESC;

oracle does not supports in the FROM it support as on select column

getting error in oracle 009933 sql command not properly ended

1 Answers1