20170308_ossdb_silver_教科書_8-3
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); INSERT INTO users VALUES (4,'渡辺',5); INSERT INTO dept VALUES (1,'総務'); INSERT INTO dept VALUES (2,'企画'); INSERT INTO dept VALUES (3,'営業'); INSERT INTO dept VALUES (4,'開発');