Related Post: Postgresql Left Join Multiple Tables With Where Clause Left Join Multiple Tables With Where Clause Left Join Two Tables With Where Clause Left Join Plus Where Clause