Related Post: Sql Server Case Statement In Left Join Sql Server Left Join Conditions In On Vs Where Clause Sql Server Left Join Example Left Join Where Clause Sql Server When In Where Clause