56,678
社区成员
发帖
与我相关
我的任务
分享
select b.name,(select case when b.column = 'a1' then a1 when b.column = 'a2' then a2 when b.column = 'a2' then a2 from a where a.id = b.id) as val from b
select B.name,
(case B.column
when 'a1' then A.a1
when 'a2' then A.a2
when 'a3' then A.a3
else 0
end) value
from A,B where A.id=B.id