+ 4

instead of ON clause we can declare our condition in where clause in join ?

12th Jul 2016, 5:12 AM
Suryaprakash Tiwari
Suryaprakash Tiwari - avatar
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.
14th Jul 2016, 6:47 PM
Suryaprakash Tiwari
Suryaprakash Tiwari - avatar
+ 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
14th Jul 2016, 6:41 PM
Tijo Joseph
Tijo Joseph - avatar
+ 1
You can but thats not ANSI standard
12th Jul 2016, 9:21 AM
Ashutosh Singh
+ 1
on must have= sign only while where can have all the operators
15th Jul 2016, 6:49 AM
manish rawat
manish rawat - avatar
where is sarg (search argument) so here we put general conditions. we must use ON only for joins
4th Nov 2016, 11:30 AM
Julio Cezar
Julio Cezar - avatar