Strange question

I'm currently preparing to 1z0-007 exam, and I'm trying to solve some of the exam problems from the TestKing publication. I've come across a strange problem:

"A SQL query cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause"

According to the provided answers, this is FALSE. However, I typed into SQL*PLUS a following statement:

SELECT e.last_name, (SELECT d.location_id FROM departments d

                                         WHERE d.department_id = e.department_id) LOCATION FROM employees e
/

(I'm working with the HR schema provided with Oracle database)

....and it works perfectly, even though table d is not referenced in the main query's FROM clause....

Is it a mistake in the TesKing's material??? Received on Thu Mar 10 2005 - 14:33:10 CST