Related Post: Left Outer Join With Where Clause Oracle Left Outer Join In Oracle With Where Condition Left Outer Join After Where Clause