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