- $sql .= ", ".$type_name." as type";
- $sql .= " FROM $table_name ";
+ $sql .= ", t.$type_name as type";
+ $sql .= " FROM $table_name t LEFT JOIN ".TB_PREF."voided v ON"
+ ." t.$trans_no_name=v.id AND v.type=$filtertype";
+ if (!$trans_ref)
+ $sql .= " LEFT JOIN ".TB_PREF."refs r ON t.$trans_no_name=r.id AND r.type=$filtertype";
+
+ $sql .= " WHERE ISNULL(v.`memo_`)";