多表连接的SQL语句--简单经典

select a.*,b.* from a,b where a.id *= b.id  --相当于左联接
select a.*,b.* from a,b where a.id =* b.id  --相当于右联接
select a.*,b.* from a left join b on a.id=b.id
select a.*,b.* from a right join b on a.id=b.id