CREATE TABLE CJJTT1
(COL1 INTEGER,
COL2 VARCHAR(10)
) ;
CREATE TABLE CJJTT2
(COL1 INTEGER,
COL2 VARCHAR(10)
) ;
INSERT INTO CJJTT1 VALUES(1,'A'),(2,'B'),(3,'C');
INSERT INTO CJJTT2 VALUES(1,'NAME1'),(2,'NAME2'),(4,'NAME4');
SELECT A.COL1,B.COL2 FROM CJJTT1 A
JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
SELECT A.COL1,B.COL2 FROM CJJTT1 A
LEFT OUTER JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
3 '[Null]'
SELECT A.COL1,B.COL2 FROM CJJTT1 A
RIGHT OUTER JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
'[Null]' 'NAME4'
DROP TABLE CJJTT1;
DROP TABLE CJJTT2;
(COL1 INTEGER,
COL2 VARCHAR(10)
) ;
CREATE TABLE CJJTT2
(COL1 INTEGER,
COL2 VARCHAR(10)
) ;
INSERT INTO CJJTT1 VALUES(1,'A'),(2,'B'),(3,'C');
INSERT INTO CJJTT2 VALUES(1,'NAME1'),(2,'NAME2'),(4,'NAME4');
SELECT A.COL1,B.COL2 FROM CJJTT1 A
JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
SELECT A.COL1,B.COL2 FROM CJJTT1 A
LEFT OUTER JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
3 '[Null]'
SELECT A.COL1,B.COL2 FROM CJJTT1 A
RIGHT OUTER JOIN CJJTT2 B ON A.COL1=B.COL1;
1 'NAME1'
2 'NAME2'
'[Null]' 'NAME4'
DROP TABLE CJJTT1;
DROP TABLE CJJTT2;