Outer Join with Condition
Posted on 2012-04-02
i am joining 2 tables ..... here i am writing the query
FROM MATL_MSTR A,
WHERE A.MATL_ID = B.MATL_ID AND
A.MATL_ID = C.MATL_ID(+);
Here i want to put one more condition with the outer join table (MATL_DISPATCH) i.e C.matl_sts = '75'.
IF i am directly using this condition then i am not getting all matl_id. Please help me and explain me how to use a condition in outer join table and that should be executed only when the outer join table has the data for that matl_id.