查询在“联华公司”工作的男性职工的职工号和姓名。
SELECT E#,ENAME FROM EMP WHERE SEX=’男’AND E# IN (SELECT E# FROM WORKS WHERE C# IN (SELECT C# FROM COMP WHERE CNAME=’联华公司’));
查询在“联华公司”工作的男性职工的职工号和姓名。
SELECT E#,ENAME FROM EMP WHERE SEX=’男’AND E# IN (SELECT E# FROM WORKS WHERE C# IN (SELECT C# FROM COMP WHERE CNAME=’联华公司’));