Wednesday, August 27, 2014

alias name is sql query

String query = "select m.BANK_ID bank_slno,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='1'";


When value show as query , coloumn name will be bank_slno without BANK_ID. It is tell alias.



My write query : 

String query = "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='accountNumber'"; 

No comments:

Post a Comment