34,837
社区成员




select a.id1,a.id2,a.id3,a.dj ,sum(a.sl - b.sl)
from tablea a
left join tableb b
on a.id1 = b.id1 and a.id2 = b.id2 and a.id3 = b.id3
group by a.id1,a.id2,a.id3
select
a.id1,a.id2,a.id3,a.dj,
[sl]=a.sl-t.s1
from
a
join
(select id1,id2,id3,sum(sl)as s1 from b group by id1,id2,id3)T
on t.id1=a.id1 and t.id2=a.id2 and t.id3=a.id3
select
a.id1,a.id2,a.id3,a.dj,
[sl]=a.sl-(select sum(sl) from b where id1=a.id1 and id2=a.id2 and id3=a.id3)
from
a
select
a.id1,a.id2,a.id3,a.dj,
[sl]=a.sl-(select sum() from b where id1=a.id1 and id2=a.id2 and id3=a.id3)
from
a