@@ -, +, @@ query --- acqui/spent.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) --- a/acqui/spent.pl +++ a/acqui/spent.pl @@ -64,8 +64,7 @@ SELECT aqinvoices.invoicenumber, quantityreceived, unitprice, - datereceived, - aqorders.biblionumber + datereceived FROM (aqorders, aqbasket) LEFT JOIN biblio ON biblio.biblionumber=aqorders.biblionumber --