-1

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.

Sivakumar S
  • 5
  • 2
  • 2
    `right` and `left` are reserved keywords you need to find different aliases (and you did not actually define the alias `left`) –  Dec 10 '19 at 07:52
  • Tables have _columns_, not _fields_. – jarlh Dec 10 '19 at 08:26

1 Answers1

3

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

change right and left to some other alias name.

Himanshu
  • 3,830
  • 2
  • 10
  • 29