LEFT JOIN chart c1 ON bg.inventory_accno_id = c1.id
LEFT JOIN chart c2 ON tc.income_accno_id = c2.id
LEFT JOIN chart c3 ON tc.expense_accno_id = c3.id
LEFT JOIN chart c1 ON bg.inventory_accno_id = c1.id
LEFT JOIN chart c2 ON tc.income_accno_id = c2.id
LEFT JOIN chart c3 ON tc.expense_accno_id = c3.id