select * from a,b是内连接也可以是笛卡尔乘积

select * from a,b where a.id = b.id 是笛卡尔乘积

但是加上where条件后就是内连接，inner join。

示例：

SELECT * FROM test.employee

SELECT * FROM test.employee2

SELECT * from test.employee p1,test.employee2 p2

 

加上where条件后就是内连接了：

SELECT * from test.employee p1,test.employee2 p2
where p1.id=p2.id

也等价于：

SELECT * from test.employee p1
JOIN test.employee2 p2
on p1.id=p2.id