银行账户前台看不到

分析过程：录制sql 

SELECT TOP 1000 "ACCOUNTBANK".FID AS "ID" FROM T_BD_AccountBanks AS "ACCOUNTBANK" INNER JOIN T_BD_AccountView AS "ACCOUNT" ON "ACCOUNTBANK".FAccountID = "ACCOUNT".FID WHERE "ACCOUNTBANK".FIsClosed = '0' AND "ACCOUNTBANK".FID IN (SELECT bd.fid FROM t_bd_accountbanks AS BD LEFT OUTER JOIN T_BD_AcctBankTrusterEntries AS EN ON en.FAcctBankID = bd.fid WHERE (bd.fcompanyid IN ('c6oAAAAAIoDM567U') OR en.ftrustCompanyID IN ('c6oAAAAAIoDM567U')))

通过后台执行该sql发现 关联科目表后查不到数据，检查银行账户中科目fid 对应的科目记录已不存在

后台删除了科目记录导致，银行账号中科目id换成系统中有的科目id后 前台显示正常。