select name=
(
case
when Type='A'
then (select Name from TB_A where Id=t.Id)
when TB.Type='B'
then (select Name from TB_B where Id=t.Id)
else
''
end
)
from TB t
版权声明：本文为dianhuilu4947原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。