12
Insertion: an Example
INSERT INTO Product(name, listPrice)
SELECT DISTINCT prodName, price
FROM Purchase
WHERE prodName NOT IN (SELECT name FROM Product)
-
225 ??
camera ??
-
200
camera
Gadgets
100
gizmo
category
listPrice
name
Depends
on the implementation