select * from a,b 不加条件的话是笛卡尔乘积。
select * from a,b where a.id = b.id 加条件相当于内连接,
等价于select * from a inner join b on a.id = b.id
select * from a,b 不加条件的话是笛卡尔乘积。
select * from a,b where a.id = b.id 加条件相当于内连接,
等价于select * from a inner join b on a.id = b.id