|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
现在的语句:
select [type],[order id],[other transaction fees],"LA07" AS 账号,* from [LA07$a1:t32000] where type='Transfer'
union all
select [type],[order id],[other transaction fees],"LA09" AS 账号,* from [LA09$a1:t32000] where type='Transfer'
union all
select [type],[order id],[other transaction fees],"LA10" AS 账号,* from [LA10$a1:t32000] where type='Transfer'
union all
select [type],[order id],[other transaction fees],"LA14" AS 账号,* from [LA14$a1:t32000] where type='Transfer'
union all
select [type],[order id],[other transaction fees],"LA15" AS 账号,* from [LA15$a1:t32000] where type='Transfer'
现在的显示结果:type列满足条件的整行都显示了,且账号列在最后。
|
|