Related Post: Left Join With Where Clause Oracle Left Outer Join With Where Clause Oracle Left Join With Where Condition In Oracle Oracle Left Join Example With Where Clause Oracle Left Join Multiple Tables With Where Clause Left Join Using Where Clause Left Join Plus Where Clause