1、 查询“王林”的基本情况和所工作的部门名称;
Use yggl
Select name,sex,address,departmentname
From employees,departments
Where employees.departmentid=departmentname.departmentid
And name=’王林’;
2、 查询财务部、研发部、市场部的员工信息(要求使用三种语法分别实现);
(1) Select *
From employees,salary,departments
Where employees.departmentid=departmentname.departmentid
And employees.employeeid=salary.employeeid
And (departments.departmentname=’研发部’
Or departments.departmentname=’财务部’
Or departments.departmentname=’市场部’);
(2)
Select *
From employees join departments
on employees.departmentid=departmentname.departmentid
where departments.departmentname=’研发部’
Or departments.departmentname=’财务部’
Or departments.departmentname=’市场部’;
(3) Select *
From employees join departments
Using (departmentid)
where departments.departmentname=’研发部’
Or departments.departmentname=’财务部’
Or departments.departmentname=’市场部’;