From 128ef71de4f15f48569bceeb1df7941e3dae8894 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 --- acqui/spent.pl | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/acqui/spent.pl b/acqui/spent.pl index f05c264..f31b283 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.9.3