insert into ... select ... where ... join语法

Question

insertinto...select...where...join这样的语法为什么会报错？例如：insertintoT2(c1,c2,c3)selectt1.c1,t1.c2,t1.c3fromT1t1wheret1.c2='y'leftjoinT3t3ont1.c1=t3.c1leftjoinT4t4ont1.c1=t4.c1;

Answer 1

select
t1.c1,
t1.c2
fromT1t1
leftjoinT3t3ont1.c1=t3.c1
leftjoinT4t4ont1.c1=t4.c1
wheret1.c2='y';
RTFM