qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, | .
qq| project_id, taxkey, tax_id, chart_link) | .
qq|VALUES (?, (SELECT c.id FROM chart c WHERE c.accno = ?), | .
qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate, | .
qq| project_id, taxkey, tax_id, chart_link) | .
qq|VALUES (?, (SELECT c.id FROM chart c WHERE c.accno = ?), | .