1、1.查询员工的表中的所有信息。Select *From 员工2.查询员工考勤表中的所有信息。Select *From 员工考勤3.查询全勤的员工的所有信息。select *from 员工where (ygbh in (select ygbh from 员工考勤 where qq=是)4.从员工表中查询文化程度为初中，且性别为女的员工所有信息。select *from 员工where whcd=初中 and xb= 女 5.查询奖励为 3000 元的员工的考勤信息。select *from 员工考勤where (ygbh in (select ygbh from 员工考评 where jl=30
2、00 元)6.查询无病假的员工的考评信息。select *from 员工考评where (ygbh in (select ygbh from 员工考勤 where bj=否)7.查询无病假，有加班的员工的奖励信息。select jlfrom 员工考评where (ygbh in (select ygbh from 员工考勤 where bj=否and jb= 是)8.查询奖励为 3000 元，文化程度为初中的员工的考勤情况。select *from 员工考勤where (ygbh in (select ygbh from 员工考评 where jl=3000 元) and (ygbh in (select ygbh from 员工 where whcd=初中)
