select
A.id,
name,
count(A.id) as cntId,
sum(deal) as sumDeal,
sum(end) as sumEnd
from
A inner join B on
A.id = B.id
where
(deal = 1 or deal = 0)
and (end =1 or end = 0)
group by A.id,name
※ 引述《crossdunk (魯來又魯去)》之銘言：
: 就目前，我知道的是可以用JOIN把兩個表串在一起
: 但如果是其中一個表要計數，還是不同欄位的要如何做呢？
: 譬如：
: A
:

感謝~