11
Insertion: an Example
INSERT   INTO   Product(name)
 SELECT  DISTINCT  prodName
 FROM     Purchase
 WHERE   prodName  NOT IN (SELECT  name FROM  Product)
-
-
camera
Gadgets
100
gizmo
category
listPrice
name