17,082
社区成员
发帖
与我相关
我的任务
分享
select A.*, B.* from A,B where A.id = B.id
select A.*, B.* from A inner join B on A.id = B.id
select * from emp a left join dept d on a.deptno=d.deptno
select * from emp a,dept d where a.deptno=d.deptno(+)
select * from emp a right join dept d on a.deptno=d.deptno
select * from emp a,dept d where a.deptno(+)=d.deptno
例:select t1.*,t2.* from a表,b表 where a.id(+)=b.id
(+)号在左边表示查询出来的记录数以右边表(即 b表)的记录数为准