Posted by: oz September 24, 2006
Login in to Rate this Post:
0 
? 
?
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