SQL> select * from R
2 /

A B C
---------- ---------- ----------
4 2 5
4 3 5
6 3 4
6 5 7
7 3 2
6 6 6

6 rows selected

SQL> select * from S;

B C D
---------- ---------- ----------
3 5 7
5 2 3
2 5 6
8 8 8
2 5 6
5 2 3

6 rows selected

--左連接
select * from r
select r.*,s.* from r,s where r.b=s.b(+)
order by r.a
select r.*,s.* from r left outer join s on r.b=s.b
order by r.a
select r.*,s.* from r left join s on r.b=s.b
order by r.a
--內連接
select r.*,s.* from r inner join s on r.b=s.b
order by r.a
select r.*,s.* from r,s where r.b=s.b
--右連接
select r.*,s.* from r,s where r.b(+)=s.b
order by r.a
select r.*,s.* from r right join s on r.b=s.b
order by r.a
select r.*,s.* from r right outer join s on r.b=s.b
order by r.a
--自然連接
select r.*,s.* from r,s