select a ,
case when b IS not null then 'B'
when c IS not null then 'C'
when d IS not null then 'D' else null end
from A A
left join B on B B.b=A.a
left join C on C C.c=A.a
left join D on D D.d=A.a
就一句SQL
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024