17,089
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE tbl_Test1
(
co11 INTEGER,
col2 INTEGER
);
CREATE TABLE tbl_Test2
(
co11 INTEGER,
col2 INTEGER
);
INSERT INTO tbl_test1 VALUES(1,11);
INSERT INTO tbl_test1 VALUES(2,12);
INSERT INTO tbl_test1 VALUES(3,13);
INSERT INTO tbl_test2 VALUES(1,111);
INSERT INTO tbl_test2 VALUES(2,222);
INSERT INTO tbl_test2 VALUES(5,555);
CREATE TABLE tbl_temp AS
SELECT A.Co11 A_Col1,A.Col2 A_Col2,B.Co11 B_Col1,B.Col2 B_Col2
FROM tbl_test1 A
FULL JOIN tbl_test2 B
ON A.Co11 = B.Co11;
UPDATE tbl_temp
SET A_Col2 = B_Col2
WHERE A_Col1 = B_Col1 ;
UPDATE tbl_temp
SET A_Col1 = B_Col1,A_Col2 = B_Col2
WHERE A_col1 IS NULL;
TRUNCATE TABLE tbl_test1;
INSERT INTO tbl_test1
SELECT A_COL1,A_COL2 FROM tbl_temp