The EMP table contains these columns: You need to display the employees who have not been assigned to any department. You write the SELECT statement: What is true about this SQL statement?（）

• A、The SQL statement displays the desired results.
• B、The column in the WHERE clause should be changed to display the desired results.
• C、The operator in the WHERE clause should be changed to display the desired results.
• D、The WHERE clause should be changed to use an outer join to display the desired results.