多选题
下面哪些语句在执行时不返回错误信息，而显示检索结果?______
- A.SELECT empno,ename FROM scott.emp WHERE depmo=(SELECT dcptno FROM
scott.dept WHERE dneme NOT IN('SALES'));
- B.SELECT empno,ename FROM scott.emp WHERE depmo=(SELECT depmo FROM
scott.dept WHERE dneme IN('SALES'));
- C.SELECT empno,e.depton,dname FROM scott.emp e,scott.dept d;
- D.SELECT empno,depton,dname FROM scott.emp,scott.dept;