From fbd04fab632ee4b8b6d9f9e2315ed8711b4d23d7 Mon Sep 17 00:00:00 2001 From: Garry Collum Date: Sat, 1 May 2010 19:37:06 -0400 Subject: [PATCH] Bug 3883: Fixes blank line in routing list. The blank line was being caused by the SELECT statement in the getroutinglist fuction of C4::Serials. The LEFT join in the select statement was creating a single row result of NULL. Changed the LEFT join to an INNER join. Signed-off-by: Galen Charlton --- C4/Serials.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Serials.pm b/C4/Serials.pm index 6cef7efea6..bca9fc85de 100644 --- a/C4/Serials.pm +++ b/C4/Serials.pm @@ -2008,7 +2008,7 @@ sub getroutinglist { my $sth = $dbh->prepare( "SELECT routingid, borrowernumber, ranking, biblionumber FROM subscription - LEFT JOIN subscriptionroutinglist ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid + JOIN subscriptionroutinglist ON subscription.subscriptionid = subscriptionroutinglist.subscriptionid WHERE subscription.subscriptionid = ? ORDER BY ranking ASC " ); -- 2.20.1