select * from a join b on a.c=b.c和select * from a,b where a.c=b.c的区别

select * from a,b where a.c=b.c 等价于inner joinselect * from a, b where a.c=b.c(先取后算）
select * from a inner join b on a.c=b.c(取中带算)性能方面inner join较好
left join 会显示左表的所有列，右表没有值的null代替，right join 与之相反。