Complex Output Types

The SELECT clause can create complex structures:

SELECT Struct: (address: a, phoneNumber: a.phoneNumber)

FROM Movies m,

(SELECT m.address

FROM m.stars

WHERE m.city=“Los Angeles”)

AS a

WHERE m.title = “Sleepless in Seattle”

Previous slide

Next slide

Back to first slide

View graphic version