SELECT 类别 as 类别名称,c.产品名称,DatePart("q",发货日期)&"季度" as 发货季度,format(Sum(b.单价*数量*(1-折扣)),"¥#,##0.00;¥-#,##0.00") as 产品销售额 FROM ([订单$]a INNER JOIN [订单明细$]b ON a.订单ID = b.订单ID) INNER JOIN [产品$]c ON b.产品 =c.产品名称 where YEAR(发货日期)=1997 GROUP BY 类别,DatePart("q",发货日期)&"季度",c.产品名称