EBS常用查询语句_查询银行账户

最新推荐文章于 2023-12-13 16:10:29 发布

蜗牛先生快跑

最新推荐文章于 2023-12-13 16:10:29 发布

阅读量1k

点赞数

文章标签： ebs

本文链接：https://blog.youkuaiyun.com/u013711561/article/details/78705263

版权

select t.bank_account_num,
v.bank_name,
v.bank_branch_name,
t.bank_account_name
from ce_bank_accounts t, ce_bank_branches_v v
where 1 = 1
and v.branch_party_id = t.bank_branch_id
and t.bank_account_name not like '%失效%'
order by v.bank_name, v.bank_branch_name