Before you do a project two days, you need to modify the results of the query!
The most used method is as follows:
INSERT INTO TABLE_NAME1 (ABC, BBB, CCC) SELECT ABC, BBB, CCC from Table_name2
By temporary menu, turn the data insert!
Later, after the high-person guidance, I found that it can also changed directly when I query:
The statement is changed to the following:
INSERT INTO TABLE_NAME1 (ABC, BBB, CCC) SELECT ABC_VALUE, BBB_VALUE, CCC_VALUE from Table_name2
Happy, you have more understanding!
