两个数据表,左连接,右连接结果

SELECT * from a left join b on a.id=b.id

select * from a right join b on a.id=b.id

select * from a inner join b on a.id=b.id
select * from b inner join a on a.id=b.id

select * from a,b where a.id=b.id