SQL 9i OUTER JOIN QUERY

From: Rahul Khandpur <r_khandpur_at_yahoo.com>
Date: 6 Aug 2004 04:05:34 -0700
Message-ID: <a4fd4d33.0408060305.2ef593e3_at_posting.google.com>

hi friends,
i have one query related to oracle9i outer join condition

it is mentioned that we can't use (+) with the operand of OR and IN operators

example

select e.last_name,e.department_id,d.department_name,d.department_id  from employees e , departments d
 where e.department_id(+) = d.department_id or d.department_id = 100

this gives error =>

where e.department_id(+) = d.department_id

                          *

ERROR at line 3:
ORA-01719: outer join operator (+) not allowed in operand of OR or IN

---

but this query works fine with the IN operator, i couldn't find the reson how the following query works perfectly with IN and (+) operator.

select e.last_name,e.department_id,d.department_name,d.department_id from employees e , departments d
where e.department_id(+) in ( d.department_id)

so friends please help to find reason for this. Received on Fri Aug 06 2004 - 13:05:34 CEST