麻烦哪位大神给看一下我写的语句哪里错了，老是提示（ora-00933: SQL 命令未正确结束）

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