ORA – 00933 confusion with inner join and “as”

by

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;

More Related Contents:

  1. Difference between Oracle’s plus (+) notation and ansi JOIN notation?
  2. How to use the ‘as’ keyword to alias a table in Oracle?
  3. Oracle “(+)” Operator
  4. SQL Command not properly ended?
  5. Select First Row of Every Group in sql [duplicate]
  6. Oracle: how to UPSERT (update or insert into a table?)
  7. Comparing Dates in Oracle SQL
  8. SQL to LINQ with multiple join, count and left join
  9. Oracle SQL query: Retrieve latest values per group based on time [duplicate]
  10. GROUP BY / aggregate function confusion in SQL
  11. How do you create a temporary table in an Oracle database?
  12. What exactly do quotation marks around the table name do?
  13. JOIN two SELECT statement results
  14. How can I get column names from a table in Oracle?
  15. Mixing implicit and explicit JOINs
  16. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  17. How to check the maximum number of allowed connections to an Oracle database?
  18. Select without a FROM clause in Oracle
  19. Is there any way to flush output from PL/SQL in Oracle?
  20. Oracle insert if row does not exist
  21. SELECT INTO using Oracle
  22. Display names of all constraints for a table in Oracle SQL
  23. Does ‘Select’ always order by primary key?
  24. Query json dictionary data in SQL
  25. ORA-00972 identifier is too long alias column name
  26. What does a (+) sign mean in an Oracle SQL WHERE clause? [duplicate]
  27. SQL Inner Join On Null Values
  28. Connecting to Oracle Database using Sql Server Integration Services
  29. ORA-00933: SQL command not properly ended
  30. Update a table with data from another table

Leave a Comment