Related Post: Left Outer Join With Where Clause On Right Table Left Outer Join With Condition On Right Table Left Join With Where Clause On Right Table