SELECT ryxx.ryxm,sum(iif(lssj.xfjh=0, lssj.jfje,0))as jftjFROM (lssj INNER JOIN ryxx ON lssj.ryid=ryxx.ryid)group by ryxx.ryxm数据库是mdb文件。
æå®é çsql ä¸ï¼ä¸é´æ好å 个 sum iif çï¼æä¹åï¼è¿ä¸ªæ示æ¯ä»ä¹åå ï¼