drop view staff_v;
drop table staff;
drop table client;

create table client (
	id integer primary key,
	name text not null,
	tel text not null
);
insert into client values(1, 'SUN', '0120-99-0001');
insert into client values(2, 'IBM', '0120-99-0002');
insert into client values(3, 'NEC', '0120-99-0003');

create table staff (
	id integer primary key,
	name text not null,
	tel text not null,
	c_id integer references client(id)
);
insert into staff values(1, '田中', '11-0001', 2);
insert into staff values(2, '鈴木', '11-0002', 3);
insert into staff values(3, '山田', '11-0003', 1);

create view staff_v as
	select
			s.name as 担当者,
			s.tel as 担当者tel,
			c.name as 得意先,
			c.tel as 得意先tel
		from client c, staff s
		where c.id = s.c_id
;