Related Post: Oracle Left Join Multiple Tables With Where Clause Left Join Multiple Tables With Where Clause Left Join Two Tables With Where Clause