jcchiang

¦^´_ 1# PKKO

¸Õ¸Õ¬Ý
SELECT a.©m¦W,a.ª÷ÃB,b.¤é´Á
FROM (Select A.©m¦W,sum(b.ª÷ÃB) as ª÷ÃB
from (a inner join B on a.ID=B.ID) group by A.©m¦W  ) as a
LEFT OUTER JOIN (select a.©m¦W,b.¤é´Á  
from a,b
where b.µ²²M»P§_='True' and a.ID=b.ID  ) as b ON a.©m¦W=b.©m¦W