can we use WHERE instead of ON here? what's the difference and is it possible to use ON in place of WHERE for other queries?!

Question

SELECT column names
FROM t1 INNER JOIN t2
ON
t1.id=t2.id;

Answer 1

if u use ON that's in ANSI style . for non ANSI where will be used.