I want to use right outer join in oracle 8i. I have my query as below.
I am getting the below error.
Even while i use LEFT OUTER JOIN also, i get the same error. My query while using left outer join
The error i got for this is as below
Please let me know how to use these joins. I am using Oracle 8i
Joined: Jan 08, 2009
The problem is simple buddy, the query syntax you are using supports Oracle 9i and higher. Its called ANSI/ISO Syntax. Instead of using this, try the older one, which most of the developers use to avoid the error.
It goes like this.
This is the example of left outer join. The (+) operator is on the left side of the compare operator, if you put it on the right side you'll get the right outer join.