+ 4
instead of ON clause we can declare our condition in where clause in join ?
5 Answers
+ 4
ON is used while JOINING the table, On is not filter it is method of joining table with another table there is filter in join that is HAVING clause which can be compared with WHERE clause.
Ideally ON is much faster because on prevents result to became Cartesian products of the Two table. if you ignore ON the table become Cartesian product of each other ie N*M type.and then where clause will apply.
+ 2
Both are having different meaning. if you are using condition after ON data will be get filtered in the table level. otherwise it will be a cross join and data will be get filtered in the where clause
+ 1
You can but thats not ANSI standard
+ 1
on must have= sign only while where can have all the operators
0
where is sarg (search argument) so here we put general conditions. we must use ON only for joins