SQL> select * from t1;
ID
----------
8
2
3
4
5
6
7
7
8
9 rows selected.
SQL> select * from t2;
[@more@]ID NAME PID
---------- ---------- ----------
1 10 0
2 11 1
3 20 0
4 12 1
5 121 2
SQL> select * from t1 join t2 on t1.id=t2.id;---即inner join
ID ID NAME PID
---------- ---------- ---------- ----------
2 2 11 1
3 3 20 0
4 4 12 1
5 5 121 2
SQL> select * from t1 left join t2 on t1.id=t2.id;---即left outer join
ID ID NAME PID
---------- ---------- ---------- ----------
2 2 11 1
3 3 20 0
4 4 12 1
5 5 121 2
8
8
6
7
7
9 rows selected.
SQL> select * from t1 right join t2 on t1.id=t2.id;---即right outer join
ID ID NAME PID
---------- ---------- ---------- ----------
2 2 11 1
3 3 20 0
4 4 12 1
5 5 121 2
1 10 0
SQL> select * from t1 full join t2 on t1.id=t2.id;
ID ID NAME PID
---------- ---------- ---------- ----------
2 2 11 1
3 3 20 0
4 4 12 1
5 5 121 2
8
8
6
7
7
1 10 0
10 rows selected.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22466621/viewspace-1048018/ ，如需转载，请注明出处，否则将追究法律责任。
