有表A,B,C,D,E,F,G,他们都有字段"名称","数量","时间",查询满足"时间"在T1到T2区间,"名称"为N1的各个表的"数量"字段的和,即,满足条件的表A的"数量"和,表B的"数量"和,等等。然后将查询结果依次赋值给变量,如:X1=表A的"数量"和,X2=表B的"数量"和我是对各个表做的一个汇总,即当我查询T1到T2时间段,表中就显示如下: 表A 表B 表C 表D 表E 表F 表GN1 "数量"和 "数量"和 "数量"和 "数量"和" 数量"和 "数量"和 "数量"和N2N3N1,N2,N3为以上表的"名称"字段的值。。我是用VB 6.0 编写的代码,然后控件用的是MSFlexGrid头都要大了,在线跪求代码,万分感谢!
解决方案 »
- 请问VB中有哪个Grid可以支持多国语言啊?
- 有谁知道WINDOWS快捷方式的文件格式,介绍下
- 请问如何设定窗体的类名ClassName
- 求购药店销售管理软件源码(高分求购)
- 求!!!如何使用 vb.net 实现sql数据库的查插删功能要求实现下图
- 如何调用报表中Function控件显示的值
- 在VB程序中,“换行”和“回车换行”控制字符有什么不同呢
- 各位兄弟,讨论一下报表,有兴趣的进来看一看哟
- 超菜问题,如何在vb中写sql语句?
- 远程组件访问数据库的问题(再次贴出,询求答案)
- 【求助】MSHflexgrid 或 vsflexgrid等类似控件进行SQL连接
- 直接打开EXCEL能运行里面的宏 用VBA打开EXCEL里面的宏不能运行
FROM [
SELECT Name,SUM(Number) AS Table1,0 AS Table2,0 AS Table3,0 AS Table4,0 AS Table5,0 AS Table6,0 AS Table7 FROM A_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,SUM(Number) AS Table2,0 AS Table3,0 AS Table4,0 AS Table5,0 AS Table6,0 AS Table7 FROM B_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,0 AS Table2,SUM(Number) AS Table3,0 AS Table4,0 AS Table5,0 AS Table6,0 AS Table7 FROM C_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,0 AS Table2,0 AS Table3,SUM(Number) AS Table4,0 AS Table5,0 AS Table6,0 AS Table7 FROM D_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,0 AS Table2,0 AS Table3,0 AS Table4,SUM(Number) AS Table5,0 AS Table6,0 AS Table7 FROM E_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,0 AS Table2,0 AS Table3,0 AS Table4,0 AS Table5,SUM(Number) AS Table6,0 AS Table7 FROM F_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
UNION
SELECT Name,0 AS Table1,0 AS Table2,0 AS Table3,0 AS Table4,0 AS Table5,0 AS Table6,SUM(Number) AS Table7 FROM G_Table WHERE Time BETWEEN #2012-3-1# AND #2012-4-1# GROUP BY Name
]. AS [%$##@_Alias]
GROUP BY Name
ORDER BY Name;不清楚是不是你要的效果