A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
Select one: a. Select e, d from emp e, dept d; b. Select e, d from emp e, dept d where e# = d#; c. Select e, d from emp e, dept d where e# (+) = d#;
d. Select e, d from emp e right outer join dept d on e# = d#;