MySQL内链接inner join和where on的区别

内连接

#内连接(取两表交集)
SELECT * FROM tab1 a inner join tab2 b on a.age = b.age
#等同于
SELECT * FROM tab1 a ,tab2 b where  a.age = b.age

​​