34,588
社区成员
发帖
与我相关
我的任务
分享
--SORRY 没注意
select d.customer_name
from depositor d,account a
where d.account_number=a.account_number and branch_name='Perryridge' and branch_name
in
(select branch_name
from borrower b,loan l
where b.loan_number=l.loan_number )
or
customer_name in
(select customer_name
from borrower b,loan l
where b.loan_number=l.loan_number )
select d.customer_name
from
depositor d,account a ,borrower b,loan l
where d.account_number=a.account_number
and branch_name='Perryridge' and b.loan_number=l.loan_number
select d.customer_name
from depositor d,account a
where d.account_number=a.account_number and branch_name='Perryridge' and branch_name
in
(select branch_name,customer_name
from borrower b,loan l
where b.loan_number=l.loan_number )
or
customer_name in
(select branch_name,customer_name
from borrower b,loan l
where b.loan_number=l.loan_number )