ÓÄÀËÅÍÈÅ Ñ ÏÎÄÇÀÏÐÎÑÎÌ

Óäàëèòü âñå ïîñòàâêè äëÿ ïîñòàâùèêîâ èç Ëîíäîíà.

delete

FROM       SP

WHERE    'Ëîíäîí' =

(SELECT         ÃÎÐÎÄ

FROM              S

WHERE           S. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ =

 SP. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ);

Ñîäåðæàíèå ðàçäåëà

---