insert into table1(label1,label2,label3,lable4)
select * from
(select
a.t1 as label1,a.t2 as label2,b.t3 as label3,b.t4 as label4
from table2 a
join table4 b on a.lable5=b.lable5 and a.goodsid=b.goodsid) AS table3
转载于:https://www.cnblogs.com/aaimengyu/p/11158457.html