Related Post: Left Join With Case Statement In Sql Server Left Join With Select Statement In Sql Server Left Join Syntax In Sql Server