临时表 a_TEMP的a1、a2和b_TEMP的b1、b2都是联合索引 关联的方式如下: FROM session.a_TEMP T1 INNER JOIN session.b_TEMP T2 ON T1.a1 = T2.b1 AND T2.a2 = T1.b2 INNER JOIN c T3 ON T2.b3= T3.c1 LEFT JOIN d T6 ON T1.a3 = T6.d INNER JOIN (SELECT * FROM e WHERE e1 = '123' AND e2= '156' ) T4 ON T1.a4= T4.e3 INNER JOIN (SELECT * FROM f WHERE f1= '123' AND f2= '840' ) T5 ON T1.a4= T5.f3 INNER JOIN (select * from g where SUBSTR(g1,1,3)='ABC') T7 ON TRIM(SUBSTR(T7.g3,4,20)) = T2.b4