| Outer join with IN operator [message #102270] |
Tue, 09 April 2002 06:42  |
Neelam
Messages: 3
Registered: March 2002
|
Junior Member |
|
|
Hi,
I'm using oracle 8.1.7 . In oracle documents its mentioned that you cannot use outer join (+) with IN operator in WHERE Clause. But in my query where I'm joining 2 tables with outer join, i need to use IN operator to compare column of first table to the values in the other table. Can you please help me to find a way how to do it.
Thanks in advance.
|
|
|
|
|
|
| Re: Outer join with IN operator [message #103710 is a reply to message #102281] |
Tue, 24 February 2004 21:46  |
M.Chandra mouli
Messages: 4
Registered: February 2004
|
Junior Member |
|
|
HI,
Can help me the same thing i.e how to apply outer join for 'IN' operator. The query:-
SELECT em.esc_code, em.esc_name, em.esc_desc, es.hours, es.esc_id, es.usr_id
FROM escalation_mstr em, escalations es
WHERE em.esc_code = es.esc_code(+) AND em.esc_st = 'Y' AND comp_id(+) = 'BAA0007'
and usr_id in (select usr_id from usr_mstr where comp_id='BAA0006')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
