SELECT no,
sum(CASE 0 WHEN S.state='ÇöÀçÁøÇàÁß' THEN 1 ELSE 0 END) as »óÅ¿Ϸá
SUM(CASE 1 WHEN S.state='½ÇÆÐ'THEN 1 ELSE 0 END) AS »óÅÂÁøÇàÁß
FROM test1 A,test2 B,test 3 C
where
A.id = B.id and
B.id = C.id and
C.date >= '20040100' and C.date <= '20040199' and
GROUP BY no




sum(CASE 0 WHEN S.state='ÇöÀçÁøÇàÁß' ,count(*) ) => add?

sum && count(*) function and use ??
help me!! T T