主题：查询

Selec1t  {销进退账目}.日期,{销进退账目}.店名,{销进退账目}.对账品名,[已销售数量],[已进退数量] From (({销进退账目} Left JOIN (sele1ct 日期,店名,对账品名,sum(数量) As [已销售数量] from {销售明细} Group By 日期,店名,对账品名) as b on b.[日期] = {销进退账目}.[日期] And b.[店名] = {销进退账目}.[店名] And b.[对账品名] = {销进退账目}.[对账品名]) Left JOIN (selec1t 日期,店名,对账品名,sum(数据数量) As [已进退数量] from {进货退货} Group By 日期,店名,对账品名) as a on a.[日期] = {销进退账目}.[日期] And a.[店名] = {销进退账目}.[店名] And a.[对账品名] = {销进退账目}.[对账品名])

不是条件，我是要只统计月份的数据，而不是按日期统计