Right Outer Join in Oracle

[Eshwar Prasad]

I want to use right outer join in oracle 8i. I have my query as below.

 SELECT A.lid
FROM A
RIGHT OUTER JOIN B
ON A.lid=B.lid
ORDER BY A.lid;   

I am getting the below error.

  RIGHT OUTER JOIN t_license
      *
ERROR at line 3:
ORA-00933: SQL command not properly ended  

Even while i use LEFT OUTER JOIN also, i get the same error. My query while using left outer join

 SELECT A.lid
FROM A
LEFT OUTER JOIN B
ON A.lid=B.lid
ORDER BY A.lid;  

The error i got for this is as below

LEFT OUTER JOIN t_license
     *
ERROR at line 3:
ORA-00933: SQL command not properly ended
    

Please let me know how to use these joins. I am using Oracle 8i

[pranjal mishra]

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.

   
SQL> select e.ename, e.deptno, d.dname
         from dept d, emp e
         where d.deptno(+) = e.deptno;
 

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.

I hope this helps you out.