关系模式department(code,name)、employee(code,name,sex,dept,phone),查询“研发部”的员工信息,查询结果包括code,name,sex,phone,正确的语句是()
A.
select code,name,sex,phone from employee where dept =’研发部’;
B.
select code,name,sex,phone from employee em,department de where de.code=em.dept and de.dept=’研发部’;
C.
select code,name,sex,phone from employee em,department de where de.code=em.code and de.name=’研发部’;
D.
Select em.code,name,sex,phone from employee em,department de where de.code=em.dept and de.name=’研发部’;