列出“计算机系”与“电子工程系”不同职称的教师的TNAME和PROFESSION。
工程系,计算机系,职称
已帮助 人
-
正确答案:SELECT TNAMEPROFESSION FROM TEACHER WHERE DEPARTMENT="计算机系"AND PROFESSION NOT IN(SELECT PROFESSION FROM TEACHER WHERE DEPARTMENT="电子工程系");
SELECT TNAME,PROFESSION FROM TEACHER WHERE DEPARTMENT="计算机系"AND PROFESSION NOT IN(SELECT PROFESSION FROM TEACHER WHERE DEPARTMENT="电子工程系");
