查询 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

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.[对账品名] = {销进退账目}.[对账品名]) where {销进退账目}.日期=xxx and {销进退账目}.年=xxx and ....

主题：查询