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

Question

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

Answer 1

selectt1.c1,t1.c2fromT1t1leftjoinT3t3ont1.c1=t3.c1leftjoinT4t4ont1.c1=t4.c1wheret1.c2='y';RTFM