select a.id,a.NAME,
case when a.Number=b.Number then a.Number
else a.Number/b.Number
end Number
from a
inner join b on b.id = a.id
case when a.Number=b.Number then a.Number
else a.Number/b.Number
end Number
from a
inner join b on b.id = a.id
调试欢乐多
select a.ID, a.Name, Number = case when a.Number = b.Number then a.Number else a.Number + '/' + b.Number end
from Table_A as a
inner join Table_B as b on a.ID = b.ID
where 查询条件......
from A join B on A.ID=B.ID
from a,b
where a.id=b.id
from A, B
where A.ID=B.ID
and A.Number=B.Number
union
select A.ID,A.NAME,(A.Number/B.Number) as Number
from A, B
where A.ID=B.ID
and A.Number<>B.Number
select a.id,a.name,case when a.number=b.number then cast(a.number as varchar) else cast(a.number as varchar)+'/'+cast(b.number as varchar) end as number
from a,b
where a.id=b.id