From 769869bdcb1ed30c11d0724c63c366dc7294816e Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 19 Jan 2017 12:46:03 +0100 Subject: [PATCH] Bug 17771: aqorders.biblionumber was already part of the query Signed-off-by: Jonathan Druart Signed-off-by: Kyle M Hall --- acqui/spent.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/acqui/spent.pl b/acqui/spent.pl index f05c264aba..f31b283060 100755 --- a/acqui/spent.pl +++ b/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 -- 2.39.5