34,593
社区成员
发帖
与我相关
我的任务
分享
SELECT
CASE A.A
WHEN 1 THEN T1.C
WHEN 2 THEN T2.C
WHEN 3 THEN T3.C
WHEN 4 THEN T4.C
WHEN 5 THEN T5.C
................
ELSE 30 THEN T30.C
END C
FROM
TEST A
LEFT JOIN T1 ON A.A = T1.A
LEFT JOIN T2 ON A.A = T2.A
LEFT JOIN T3 ON A.A = T3.A
LEFT JOIN T4 ON A.A = T4.A
LEFT JOIN T5 ON A.A = T5.A
................
LEFT JOIN T30 ON A.A = T30.A