SQLÓï¾äÔÚACCESSͨ¹ý£¬µ«Ð´ÔÚMFCÀïÃæ²»ÄÜͨ¹ý

±ía
no1  name  class  score
1      A    ³õÒ»1    60
2      B    ³õ¶þ2    70
3      C    ³õÒ»2    30
4      D    ³õ¶þ1    80
5      E    ³õÒ»1    45
ͳ¼Æ¸÷Ä꼶score>=60ÈËÊý
ͳ¼Æ³ö
³õÒ»    1
³õ¶þ    2
³õÈý    0
ÔÚACCESSʹÓÃÒÔÏÂÓï¾äͨ¹ý£¬µ«ÔÚMFCÀïÃæ¾Í²»ÄÜͨ¹ý£¬ÎªÊ²Ã´ÄØ£¿
select left(class,2),sum(iif(score>=60,1,0))
from
(
select * from a
union
select distinct 1,'','³õÒ»',0 from a
union
select distinct 1,'','³õ¶þ',0 from a
union
select distinct 1,'','³õÈý',0 from a

)
group by left(class,2)

---

ÌáʾʲôÐÅÏ¢£¿Ìù³öÀ´¿´¿´

---

RUNTIME ERROR

---

´úÂëÌù³öÀ´¿´¿´£¬ÊÇCÖеģ¿

---

MFCµ±ÖУ¬ SQL.Format("SELECT left(grade,2) AS cntgrade, sum(iif(latedate >= '%s' and latedate <= '%s' and grade like '%s',1,0)) AS num from (select * from studentlate union select distinct '','','³õÒ»','','','','' from studentlate union select distinct '','','³õ¶þ','','','','' from student