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
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