INSERT   INTO   PRODUCT(name)

     SELECT  DISTINCT  Purchase.product

     FROM      Purchase

     WHERE   Purchase.date > “10/26/01”

The query replaces the VALUES keyword.

Here we insert many tuples into PRODUCT