Search code examples
sqloraclejointable-alias

ORA-00904 when for inner joining same table

My query is :

select right.* from Table1 JOIN Table1 right on (right.field1 = left.field1)

I need to expand this query even more with where clause. But this itself is throwing, ORA-00904 : invalid identifier error.

Solution

  • Right and Left are reserved keywords name for right and left join

    change right and left to some other alias name.