Find All Customers Who Have Both An Account And A Loan At The #560
This subjective question is related to the book/course
gs gs114 Relational Database Management System.
It can also be found in
gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: Find all customers who have both an account and a loan at the bank
where b1.customer_name = b2.customer_name);
Answer:
select distinct customer_name from borrower as b1 where exists (select customer_name from depositor as b2where b1.customer_name = b2.customer_name);
