t1,t2,t3我都单独侧过了,是没问题的简化一下就是select T1.*,t2.wgcs,t2.wgje,t3.cgcs.t3.cgje from t1
left join t2
into t1.pru_id = t2.pru_id and t1.yyid = t2.yyid
left join t3
into t1.pru_id = t3.pru_id and t1.yyid = t3.yyid有什么问题?
left join t2
into t1.pru_id = t2.pru_id and t1.yyid = t2.yyid
left join t3
into t1.pru_id = t3.pru_id and t1.yyid = t3.yyid有什么问题?
left join tablename2 t2
on t1.pru_id = t2.pru_id and t1.yyid = t2.yyid
left join tablename3 t3
on t1.pru_id = t3.pru_id and t1.yyid = t3.yyid