SELECT a.a_b,b.b_a,b.b_b FROM
(SELECT t1.a as a_a,t1.b as a_b FROM table1 t1 WHERE length(t1.a) = 3) a
,
(SELECT substr(t2.a,1,3) AS sub_b_a,t2.a as b_a,t2.b as b_b FROM table1 t2 WHERE length(t2.a) = 7) b
WHERE a.a_a = b.sub_b_a
如果有别名不对的地方自己改改~~
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024