Related Post: Left Join With Where Clause Postgres Postgresql Left Join Multiple Tables With Where Clause Left Join Where Clause Left Join Example With Where Clause Left Join Using Where Clause Can We Use Where Clause With Left Join