# retrieve individual rows
$query = qq|SELECT c.accno, t.taxkey AS accnotaxkey, a.amount, a.memo,
a.transdate, a.cleared, a.project_id, p.projectnumber,(SELECT p.projectnumber FROM project p
# retrieve individual rows
$query = qq|SELECT c.accno, t.taxkey AS accnotaxkey, a.amount, a.memo,
a.transdate, a.cleared, a.project_id, p.projectnumber,(SELECT p.projectnumber FROM project p