INNER JOIN Where Clause
sql, sql-server
Solution
Not with an inner join. An outer join is where placement will make a difference.
Problem
Is there a difference between doing something like ``` SELECT * FROM table1 INNER JOIN table2 ON table2.ObjectId = table1.table2ObjectId WHERE table2.Value = 'Foo' ``` vs ``` SELECT * FROM table1 INNER JOIN table2 ON table2.ObjectId = table1.table2ObjectId AND table2.Value = 'Foo' ```