テストテーブル [SQL]
sqlite テスト用 create table emp (emp_id NUMBER NOT NULL, name TEXT,department_id NUMBER,sarary NUMBER); insert into emp values (001,'caesar',100,1000); insert into emp values (002,'scipio',100,2000); insert into emp values (003,'augustus',100,3000); insert into emp values (004,'testtest',90,20); insert into emp values (005,'aaaaaa',90,1000); create table department (department_id NUMBER NOT NULL,dept_name TEXT); insert into department values (100,'senatus'); insert into department values (90,'princepus'); insert into department values (600,'german'); 結合してみる。 SELECT d.department_id,dept_name, name, sarary FROM department d LEFT OU TER JOIN emp e ON d.department_id = e.department_id; JUGEMテーマ： コンピュータ .dumpすればSQLをはける。 sqlite>.dump BEGIN TRANSACTION; DELETE FROM sqlite_sequence; CREATE TABLE emp (emp_id NUMBER NOT NULL, name TEXT,department_id NUMBER,sarary NUMBER); INSERT INTO "emp" VALUES(1,'caesar',1