所有列
INSERT INTO table2
SELECT * FROM table1;
选择列插入：
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;
INSERT INTO CustomerOrders (CustomerID, OrderID, OrderDate)
SELECT Customers.CustomerID, Orders.OrderID, Orders.OrderDate
FROM Customers
JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Customers.CustomerName = 'John Doe';