Search code examples
sqloraclejointable-alias

ORACLE sql error - ORA-00933 - executing join operation - DBeaver

I'm trying to execute the next:

SELECT l.id AS id
FROM s.process AS l 
JOIN s.item AS r ON l.id = r.id;

But I'm getting:

Query execution failed
Reason:
SQL Error [933] [42000]: ORA-00933: SQL command not properly ended

Using:

  • DBeaver
  • ojdbc7.jar as driver
Solution

  • You have to remove AS when defining alias of table/view:

    SELECT l.id AS id
FROM s.process l 
JOIN s.item r ON l.id = r.id;