多个数据表透视组合的问题, +一列知道数据来源

cyn_sg

论坛里有好多例子讲解了如何运用SQL Union来组合多数据源
可加入表明的字段表示源自哪张表, 例句如下:
SELECT '1' as 'source', *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\1`.`A$` `A$` union all  
SELECT '2' as 'source', *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\2`.`A$` `A$`
组合consolidation folder下表1 和2的sheet A.
如果有很多表, 可不可以更灵活的给这个字段辅值, 使source=相应的需输入的workbook.sheet.name
用数组或指定区域表示所需文件名?
这样语句可以更灵活

[ 本帖最后由 cyn_sg 于 2009-4-17 09:41 编辑 ]

BIN_YANG168

SELECT "1", *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\1`.`A$` `A$` union all  
SELECT "2",  *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\2`.`A$` `A$`

cyn_sg

板主, 谢谢啊
可是奇怪的是, 我如果按照你的
SELECT "1", *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\1`.`A$` `A$` union all  
SELECT "2",  *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\2`.`A$` `A$`

windows error提示: too few parameters. Expected 1
我试了试, SELECT 1, *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\1`.`A$` `A$` union all  
SELECT 2,  *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\2`.`A$` `A$`
到是通过了
我是excel 2003版的, " "到底要不要加呀
如果加'1', 到是可以的

[ 本帖最后由 cyn_sg 于 2009-4-16 14:18 编辑 ]

monvzhilei

语句应该是没有错的。

cyn_sg

SELECT '1' as 'source', *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\1`.`A$` `A$` union all  
SELECT '2' as 'source', *  FROM `C:\Documents and Settings\Desktop\excel\consolidation\2`.`A$` `A$`
如果有很多表, 可不可以这个字段的名称source=workbook.sheet.name?
可以更灵活的输入这个source字段吗, 以数组或指定区域表示所需文件名?

[ 本帖最后由 cyn_sg 于 2009-4-17 09:34 编辑 ]