ALLBASE/SQL Reference Manual (36216-90216)

518 Chapter12
SQL Statements S - Z
SELECT
Insert into table T, supplier names of each supplier who does not supply any part.
INSERT INTO T (SNO)
SELECT SNO
FROM S
WHERE NOT EXISTS (SELECT *
FROM SP
WHERE SP.SNO = S. SNO)
Delete all suppliers from the supplier table who do not supply any parts.
DELETE FROM S
WHERE NOT EXISTS ( SELECT *
FROM SP
WHERE SP.SNO = S.SNO)