我正在努力寻找组合这两个查询的方法...我尝试过子查询、连接、联合，但都没有成功:(查询ASELECTDATE(crtdtime)AScntldate,sd_class,COUNT(crtdtime)AScreatedFROMmasterWHEREDATE(crtdtime)='2011-11-16'GROUPBYcntldate,sd_class产生+------------+----------+---------+|cntldate|sd_class|created|+------------+----------+---------+|2011-11-16|CUST|2226|