SQL Sever 中(branch-name, customer-name) in XX 是不对的

最新推荐文章于 2020-12-02 01:12:20 发布

陳紋欽

最新推荐文章于 2020-12-02 01:12:20 发布

阅读量871

点赞数

分类专栏： SQL Server 2008

本文链接：https://blog.csdn.net/cjx798280904/article/details/14692051

版权

SQL Server 2008 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

可以改为如下语句：

select distinct customer_name 
from borrower,loan
where borrower.loan_number = loan.loan_number and 
      branch_name = 'Perryridge' and
      --branch_name in (select branch_name   --感觉这两行可以去掉，欢迎留言
      --from depositor,account where depositor.account_name = account.account_name) and
      customer_name in (select customer_name
      from depositor,account where depositor.account_name = account.account_name)