Fig02 02

(SELECT er>pid .FRCtóf im'oice

WHERE invoic©_nuntber = 5640));

SELECT e.empid, e.salary EROM *mp e WHERE e.dopt =

(SELECT dopt PROM omp WHERE ompid =

Outermost <|ixry In $dect statonent; DEPT column « global co a II subquerie$

First subquerv; EMPID ids local to tF subquery but global to the fdlowing $ubquery

Irmeimost subquery; INVOłCE_NUMBER is local to this query only