Related Post: Oracle Left Join Example With Where Clause Oracle Left Outer Join Example Where Clause Left Join Example With Where Clause Oracle Join Example With Where Clause Left Join Using Where Clause