Write a query to find the distinct customers and branch names of the branches situated in the city “Hyderabad” where the customers have taken the loans

Write a query to find the distinct customers and branch names of the branches situated in
the city “Hyderabad” where the customers have taken the loans

2Comments
shivani @shivani1234
2 Oct 2017 08:32 pm

customer(cust_name, loan_id)
bank(branch_name, city , loan_no.)
π cust_name , branch_name (σ(city="hyderanad " ^ loan_id =loan _no.)(customer |x| bank))

karmjit joshi @karmjitjoshi
2 Oct 2017 08:38 pm

thanks