convert the following nested query to one without any innerquery (use a join).
Select d.dname from department d
where d.dnumber in (select e.dno from employee e, works_on wwhere e.ssn = w.essn and w.pno = 20);
Expert Answer
An answer will be send to you shortly. . . . .