|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
OLEDB查询
SQL语句
- Select distinct 配件编号,配件名称 from
- (
- select 配件编号,配件名称 from [sheet3$a:b]
- union all
- select 配件编号,配件名称 from [sheet4$a:b]
- union all
- select 配件编号,配件名称 from [sheet5$a:b]
- union all
- select 配件编号,配件名称 from [sheet6$a:b]
- union all
- select 配件编号,配件名称 from [sheet7$a:b]
- union all
- select 配件编号,配件名称 from [sheet8$a:b]
- union all
- select 配件编号,配件名称 from [sheet9$a:b]
- union all
- select 配件编号,配件名称 from [sheet10$a:b]
- union all
- select 配件编号,配件名称 from [sheet11$a:b]
- union all
- select 配件编号,配件名称 from [sheet12$a:b]
- union all
- select 配件编号,配件名称 from [sheet13$a:b]
- union all
- select 配件编号,配件名称 from [sheet14$a:b]
- )
- where 配件编号 is not null
复制代码
|
|