http://www.sqlteam.com/article/using-select-to-insert-records
INSERT INTO SELECT
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information
http://www.sqlteam.com/article/using-select-to-insert-records
INSERT INTO SELECT
INSERT INTO Store_Information (store_name, Sales, Date)
SELECT store_name, Sales, Date
FROM Sales_Information