Related Post: Left Join Plus Where Clause Left Join Using Where Clause Left Join Example With Where Clause