SELECT 业务员品种客户表.业务员编号, 业务员品种客户表.客户编号, 业务员品种客户表.商品编号, (select nz(sum(数量),0) from 经营表 where 经营表.日期< #2008-1-1# and 经营表.客户编号=业务员品种客户表.客户编号 and 业务员品种客户表.商品编号=经营表.商品编号) AS 销售之前08总和, (select nz(sum(数量),0) from 经营表 where 经营表.日期> #2008-1-1# and 经营表.客户编号=业务员品种客户表.客户编号 and 业务员品种客户表.商品编号=经营表.商品编号) AS 销售之后08总和
FROM 业务员品种客户表;
欢迎光临 Office中国论坛/Access中国论坛 (http://www.office-cn.net/) | Powered by Discuz! X3.3 |