哎,终于给你弄出来了,有不明白的地方问我就是,我在线:select '8月2日' as 时间,产品ID,sum(a尺寸60) as 尺寸60,sum(a尺寸65) as 尺寸65 from(select 产品ID,iif(isnull(sum(尺寸60)),0,sum(尺寸60)) as a尺寸60,iif(isnull(sum(尺寸65)),0,sum(尺寸65)) as a尺寸65 from 表1 where 时间<=cdate('2009-8-2') group by 产品ID union allselect 产品ID,iif(isnull(sum(尺寸60)),0,sum(尺寸60))*-1 as a尺寸60,iif(isnull(sum(尺寸65)),0,sum(尺寸65))*-1 as a尺寸65 from 表2 where 时间<=cdate('2009-8-2') group by 产品ID) group by 产品ID这下终于可以用了,我开始做的时候是在工具里边连得access数据库,所以没报错,access的语法太别扭了啊,不如sqlser用起来方便以上,希望对你有所帮助
|