111,094
社区成员




select *,case when a.a_money=b.b_money
then '相等' else '不相等' end '相等'
from tba a inner join tbb b on charindex(b.b_danwei,a.a_danwei)>0
select A.a_id,a.a_danwei,b.b_danwei,a.a_money,b.b_money ,
(case when a.a_money=b.b_money then '相等' else '不相等' end) t
from tableA as a,TableB as b
where CHARINDEX(b.b_danwei,a.a_danwei)>0
order by a_id
select a_id,a_danwei,b_danwei,a_money,b_money,case when a_money=b_money then '相等' else then '不等' end as jieguo from 表1 left join 表2 on 表1.a_id=表2.b_id