sql - INNER JOIN Where Clause -
this question has answer here:
- sql join: clause vs. on clause 13 answers
is there difference between doing like
select * table1 inner join table2 on table2.objectid = table1.table2objectid table2.value = 'foo'
vs
select * table1 inner join table2 on table2.objectid = table1.table2objectid , table2.value = 'foo'
not inner join. outer join placement make difference.
Comments
Post a Comment