ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

Á½±í,
A ±í(¶©µ¥)
order style customer qty
1000 22 33 10
1000 22 33 -4
1000 22 33 -1
1000 44 33 8
1000 44 33 -4

B±í(Òѳö»õ)
order style customer qty
1000 22 33 2
1000 22 33 1
1000 44 33 3

ÏëµÃµ½ÒÔÏÂÊ£ÓàÁ¿

order style customer qty
1000 22 33 2
1000 44 33 1

лл!
 

  

---

SQL code:

select a.order,a.style,a.customer,(sum(a.qty)-sum(b.qty)) qty
from a,b
where a.order=b.order,a.style=b.style,a.customer=b.customer
group by a.order,a.style,a.customer

---

SQL code:

select a.order,a.style,a.customer, (a.qty-b.qty) as [qty]
from (select order,style,cusomer,sum(qty) as qty
from tb_a
group by order,style,cusomer) a left join (select order,style,cusomer,sum(qty) as qty
from tb_b
group by order,style,cusomer)b
on a.order=b.order and a.style=b.style and a.customer=b.customer

---

ÎÒ·¢ÏÖÎÒÊÇ×µÄ