多表联合查询的准备工作
use mydb3;
create table if not exists dept3
(
deptno varchar(20),
name varchar(20)
);
create table if not exists emp3
(
eid varchar(20) primary key,
ename varchar(20),
age int,
dept_id varchar(20)
);
insert into dept3 values('1001','研发部');
insert into dept3 values('1002','销售部');
insert into dept3 values('1003','财务部');
insert into dept3 values('1004','人事部');
insert into emp3 values('1','乔峰',20,'1001');
insert into emp3 values('2','段誉',21,'1001');
insert into emp3 values('3','虚竹',23,'1001');
insert into emp3 values('4','阿紫',18,'1001');
insert into emp3 values('5','扫地僧',85,'1002');
insert into emp3 values('6','李秋水',33,'1002');
insert into emp3 values('7','鸠摩智',50,'1002');
insert into emp3 values('8','天山童姥',60,'1003');
insert into emp3 values('9','慕容博',58,'1003');
insert into emp3 values('10','丁春秋',71,'1005');
丁春秋是为了以后的需要加上的