SELECT `ca`.*, `ca`.`ID` caID, `b`.*, `b`.`ID` bankID
FROM (`comp_bank` b)
LEFT JOIN `comp_chart_of_acct` ca ON `ca`.`ID` = `b`.`linkAccountID`
WHERE `b`.`is_delete` =  0
AND `b`.`companyID` =  '3'