SELECT a.*, a.transNo AS `formNo`, b.bankName, c.acctCode
FROM (`comp_unpresented_check` a)
LEFT JOIN `comp_bank` b ON `b`.`ID` = `a`.`bankID`
LEFT JOIN `comp_chart_of_acct` c ON `c`.`ID` = `b`.`linkAccountID`
WHERE `a`.`companyID` =  '3'
AND `a`.`is_delete` =  0