From ca9381cb47982f68d46877366b059bf2e1411f96 Mon Sep 17 00:00:00 2001 From: tipaul Date: Thu, 3 Aug 2006 13:11:37 +0000 Subject: [PATCH] fix for buggy SQL --- C4/Acquisition.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index cf22042627..bdd204ede2 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -504,7 +504,7 @@ sub getallorders { my $dbh = C4::Context->dbh; my @results = (); my $strsth ="Select authorisedby,creationdate,aqbasket.basketno, -closedate,surname,firstname,aqorders.biblionumber,aqorders.title,aqorders.author,aqorders.isbn, aqorders.ordernumber, quantity, quantityreceived +closedate,surname,firstname,aqorders.biblionumber,aqorders.title, aqorders.ordernumber, quantity, quantityreceived from aqorders left join aqbasket on aqbasket.basketno=aqorders.basketno left join borrowers on aqbasket.authorisedby=borrowers.borrowernumber -- 2.39.5