What's the difference between INNER JOIN and a join in the WHERE clause (... =...) ?

Answer 1

"INNER JOIN" clause join tables and WHERE filter data, but you can use WHERE for join tables, but if you want join 2 tables and filter specific records,for example, SELECT * FROM 'cat' INNER JOIN 'dog' ON 'cat.id' = 'dog.id' WHERE 'cat.color' = 'black';

Answer 2

both of them are same