一、准备
表一:
CREATE TABLE
T1
(
USERID INTEGER,
USERNAME VARCHAR(20),
PASSWORD VARCHAR(20)
)
数据:
表二:
CREATE TABLE
T3
(
USERID INTEGER,
JF INTEGER,
DJ INTEGER
)
数据:
二、相关查询
1、内联
SELECT
*
FROM
DB2ADMIN.T1
INNER JOIN
DB2ADMIN.T3
ON
t1.USERID=t3.USERID ;
2、左外联
SELECT
*
FROM
DB2ADMIN.T1
LEFT OUTER JOIN
DB2ADMIN.T3
ON
t1.USERID=t3.USERID ;
3、右外联
SELECT
*
FROM
DB2ADMIN.T1
RIGHT OUTER JOIN
DB2ADMIN.T3
ON
t1.USERID=t3.USERID ;
4、全联
SELECT
*
FROM
DB2ADMIN.T1
FULL OUTER JOIN
DB2ADMIN.T3
ON
t1.USERID = t3.USERID;