20170307_ossdb_silver_教科書_8-2

CREATE TABLE table_1 (
KeyA text,
KeyB text
);

CREATE TABLE table_2 (
KeyA text,
KeyB text
);

INSERT INTO table_1 VALUES ('table_X','X');
INSERT INTO table_1 VALUES ('table_Y','Y');
INSERT INTO table_1 VALUES ('table_Z','Z');

INSERT INTO table_2 VALUES ('table_1','X');
INSERT INTO table_2 VALUES ('table_2','Y');
INSERT INTO table_2 VALUES ('table_3','Z');

検証中
CREATE TABLE table_3 (
keyA text,
keyB text
);

INSERT INTO table_3 VALUES ('KeyA','X');
INSERT INTO table_3 VALUES ('KeyB','Y');
INSERT INTO table_3 VALUES ('KeyC','Z');
INSERT INTO table_3 VALUES ('KeyB','X');