SQL 指南書集 目次 - ray88’s diary
■完全外部結合とマージ文
テーブル作成SQL
/* 完全外部結合 */ CREATE TABLE Class_A (id char(1), name varchar(30), PRIMARY KEY(id)); CREATE TABLE Class_B (id char(1), name varchar(30), PRIMARY KEY(id)); INSERT INTO Class_A (id, name) VALUES('1', '田中'); INSERT INTO Class_A (id, name) VALUES('2', '鈴木'); INSERT INTO Class_A (id, name) VALUES('3', '伊集院'); INSERT INTO Class_B (id, name) VALUES('1', '田中'); INSERT INTO Class_B (id, name) VALUES('2', '内海'); INSERT INTO Class_B (id, name) VALUES('4', '西園寺');