Related Post: Left Join With Where Clause And Group By Left Join Example With Where Clause Left Join Using Where Clause How To Use Group By In Left Join Left Join Plus Where Clause