Query Practice

Query Practice :
=============
Bank Account :
..........................
..........................


select m.BANK_ID,m.BANK_NAME,c.BRANCH_NAME,d.AUTO_AC_NO
from fn_bank m, fn_bank_branch c, fn_bankacc d
where m.BANK_ID = c.BANK_ID
and c.BANK_SLNO = d.BANK_SLNO
and m.BANK_ID='B11002000001'





select m.BANK_NAME,n.BRANCH_NAME,p.AUTO_AC_NO from fn_bank m, fn_bank_branch n,fn_bankacc p where AUTO_AC_NO='1000000004351'


select m.BANK_NAME,n.BRANCH_NAME,n.BRANCH_ADDRESS,n.MOBILE_NO,n.PHONE_NO,n.FAX,n.E_MAIL,n.WEB_ADDRESS,n.DESCRIPTION,p.AUTO_AC_NO from fn_bank m, fn_bank_branch n,fn_bankacc p where AUTO_AC_NO='1000000004351'