NC银行账号

SELECT bank.pk_cust,bank.isdefault,acc.code,acc.accname,acc.accnum 
FROM  bd_custbank bank,bd_bankaccsub acc WHERE bank.pk_bankaccbas=acc.pk_bankaccbas(+)
AND bank.Pk_Cust='1001IN100000011PK3WO';