CREATE TABLE tbl1 ( id int PRIMARY KEY, name text ); CREATE TABLE tbl2 ( id int PRIMARY KEY, name text ); INSERT INTO tbl1 VALUES (1,'AAA'); INSERT INTO tbl1 VALUES (2,'BBB'); INSERT INTO tbl1 VALUES (3,'CCC'); INSERT INTO tbl2 VALUES (2,'…

CREATE TABLE users ( id int PRIMARY KEY, 名前 text, 部署id int ); CREATE TABLE dept ( 部署id int PRIMARY KEY, 部署 text ); INSERT INTO users VALUES (1,'鈴木',2); INSERT INTO users VALUES (2,'佐藤',3); INSERT INTO users VALUES (3,'田中',4);…