Related Post: Can You Use A Where Clause In A Left Join Can I Use Where Clause In Left Join Can We Use Where Clause In Left Outer Join How To Use Left Join In Where Clause How To Add Where Clause In Left Join Can I Use Where Clause In Inner Join