|
现在的语句:
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列满足条件的整行都显示了,且账号列在最后。
|
|