Complications in the FROM Clause

SELECT a.phoneNumber

FROM Movies m,

(SELECT m.address

FROM m.stars

WHERE m.city=“Los Angeles”)

AS a

WHERE m.title = “Sleepless in Seattle”

The FROM clause can contain arbitrary subqueries that return

collections.

Previous slide

Next slide

Back to first slide

View graphic version