Question: what is the difference between left join with where clause & left join without where clause?
Answer: Case 2: Left Outer join without On and Where Clause When you use a Left Outer join without an On or Where clause, there is no difference between the On and Where clause. Both produce the same result as in the following. First we see the result of the left join using neither an On nor a Where clause.