ÎÁÍÎÂËÅÍÈÅ Ñ ÏÎÄÇÀÏÐÎÑÎÌ
Óñòàíîâèòü îáúåì ïîñòàâîê ðàâíûì íóëþ äëÿ âñåõ ïîñòàâùèêîâ èç Ëîíäîíà.
UPDATE SP
SET ÊÎËÈ×ÅÑÒÂÎ = Î
WHERE 'Ëîíäîí' =
(SELECT ÃÎÐÎÄ FROM S
WHERE S. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ =
SP. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ);
Óñòàíîâèòü îáúåì ïîñòàâîê ðàâíûì íóëþ äëÿ âñåõ ïîñòàâùèêîâ èç Ëîíäîíà.
UPDATE SP
SET ÊÎËÈ×ÅÑÒÂÎ = Î
WHERE 'Ëîíäîí' =
(SELECT ÃÎÐÎÄ FROM S
WHERE S. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ =
SP. ÍÎÌÅÐ_ÏÎÑÒÀÂÙÈÊÀ);