More Interesting Insertions

INSERT INTO PRODUCT(name)

SELECT DISTINCT product

FROM Purchase

WHERE product NOT IN

(SELECT name

FROM Product)

The query replaces the VALUES keyword.

Note the order of querying and inserting.