MySQL实验四数据库的查询_实验四 数据库查询--2

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=’市场部’;