具体场景：对银行账户常用的字段进行梳理，并关联相关表。 ```sql SELECT TBA.FNUMBER AS FNUMBER , TBA.FNAME_L2 AS FNAME, TBA.FBANKACCOUNTNUMBER AS FBANKACCOUNTNUMBER, TOB.FNAME_L2 AS TOBFNAME, TBA.FISCLOSED AS FISCLOSED , TBA.FOPENDATE AS FOPENDATE, TBB.FNAME_L2 AS TBBFNAME, TBA.FISSETBANKINTERFACE AS FISSETBANKINTERFACE, TBAP.FNAME_L2 AS TBAPNAME, TBA.FACCOUNTTYPE AS FACCOUNTTYPE, TBA.FACCTNAME AS FACCTNAME, TBA.FBANKINTERFACE AS FBANKINTERFACE, TBA.FBANKINTERFACEID AS FBANKINTERFACEID, TBA.FISDEFAULTPAYMENT AS FISDEFAULTPAYMENT, TBA.FACCOUNTBANKTYPE AS FACCOUNTBANKTYPE FROM T_BD_ACCOUNTBANKS TBA LEFT JOIN T_ORG_BASEUNIT TOB ON TBA.FCOMPANYID = TOB.FID LEFT JOIN T_BD_BANK TBB ON TBA.FBANK = TBB.FID LEFT JOIN T_BD_ACCOUNTPROPERTY TBAP ON TBA.FPROPERTYID = TBAP.FID ```