From a23c2d7690e225a51ad2d75ccd453d23878004d4 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 1 Apr 2009 14:43:47 +0200 Subject: [PATCH] (bug #3080) fix the acqui/spent.pl Content-Type: text/plain; charset="utf-8" this patch fix the sql request used in spent.pl --- acqui/spent.pl | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/acqui/spent.pl b/acqui/spent.pl index f73537b..af6f1ea 100755 --- a/acqui/spent.pl +++ b/acqui/spent.pl @@ -33,7 +33,7 @@ my $query = quantity-quantityreceived as tleft, aqorders.ordernumber as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno - from aqorders,aqorderbreakdown,aqbasket + from aqorderbreakdown,aqbasket,aqorders left join biblioitems on biblioitems.biblioitemnumber=aqorders.biblioitemnumber where bookfundid=? and aqorders.ordernumber=aqorderbreakdown.ordernumber and -- 1.5.6.3