sql中的join 使用

自然连接： select * from stu s,cause c where s.id=c.sid;内连接 select * from stu s inner join cause c on s.id=c.sid where s.name='AAA'; select * from stu s join cause c on s.id=c.sid; 外连接 左外连接 select * from stu s left outer join cause c on s.id=c.sid; select * from stu s,cause c where s.id=c.sid(+); 右外连接 select * from stu s right outer join cause c on s.id=c.sid; select * from stu s,cause c where s.id(+)=c.sid; 全外连接 select * from stu s full outer join cause c on s.id=c.sid; 交叉连接 select * from stu s cross join cause c;