I have 4 table(acct, customer, loan and branch) now i need to write a sql statement to find the name of every customer who have an acct in every branch that one customer(let say X) has an acct in..

Any help???????? would be appriciated. Thanks.

select * from customer, branch, account where customer.=branch.id and branch.=account.id

This statement will give you all the customers who have an account in every branch.

View/Share this post only

I believe table Loan has nothing to do with the problem and following will solve your problem :

SELECT Account.CustNo From Account Where Account.BranchNo in (SELECT Account.BranchNo FROM Account WHERE Account.CustNo = 1)

Good Luck