vCopying Parts of
Tables
oINSERT
INTO <receiving
table> <receiving table’s column names>
SELECT <column names of the columns
to be copied>
FROM
<contributing table name>;
o
oExample:
;INSERT INTO PART (PART_CODE, PART_DESCRIPT, PART_PRICE)
SELECT P_CODE, P_DESCRIPT,
P_PRICE
FROM
PRODUCT;