@@ -, +, @@ --- acqui/ordered.pl | 3 +-- acqui/spent.pl | 3 +-- 2 files changed, 2 insertions(+), 4 deletions(-) --- a/acqui/ordered.pl +++ a/acqui/ordered.pl @@ -58,7 +58,7 @@ SELECT ecost_tax_included, budgetdate, entrydate, aqbasket.booksellerid, aqbooksellers.name as vendorname, - itype, + GROUP_CONCAT(DISTINCT itype), title FROM (aqorders, aqbasket) LEFT JOIN biblio ON @@ -80,7 +80,6 @@ WHERE ecost_tax_included, budgetdate, entrydate, aqbasket.booksellerid, aqbooksellers.name, - itype, title EOQ --- a/acqui/spent.pl +++ a/acqui/spent.pl @@ -59,7 +59,7 @@ SELECT quantity-quantityreceived AS tleft, budgetdate, entrydate, aqbasket.booksellerid, - itype, + GROUP_CONCAT(DISTINCT itype), title, aqorders.invoiceid, aqinvoices.invoicenumber, @@ -88,7 +88,6 @@ WHERE tleft, budgetdate, entrydate, aqbasket.booksellerid, - itype, title, aqorders.invoiceid, aqinvoices.invoicenumber, --