Correlated

SELECT pub_nameFROM publishers pWHERE ‘business’ IN (SELECT type FROM titles WHERE pub_id = p.pub_id)

• The outer query executes first.

• The inner query executes for every ROW the outer query returns and completes the evaluation.

Previous slide

Next slide

Back to first slide

View graphic version