[Koha-cvs] koha/C4/Circulation Circ2.pm [rel_2_2]

[Chris Cormack]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Chris Cormack <rangi>   07/07/15 21:39:40

Modified files:
        C4/Circulation : Circ2.pm 

Log message:
        Fix for bug 1384, changing itemtypes join into a left join

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/Circulation/Circ2.pm?cvsroot=koha&only_with_tag=rel_2_2&r1=1.87.2.27&r2=1.87.2.28

Patches:
Index: Circ2.pm
===================================================================
RCS file: /sources/koha/koha/C4/Circulation/Attic/Circ2.pm,v
retrieving revision 1.87.2.27
retrieving revision 1.87.2.28
diff -u -b -r1.87.2.27 -r1.87.2.28
--- Circ2.pm    25 Jun 2007 14:43:13 -0000      1.87.2.27
+++ Circ2.pm    15 Jul 2007 21:39:39 -0000      1.87.2.28
@@ -3,7 +3,7 @@
 
 package C4::Circulation::Circ2;
 
-# $Id: Circ2.pm,v 1.87.2.27 2007/06/25 14:43:13 rych Exp $
+# $Id: Circ2.pm,v 1.87.2.28 2007/07/15 21:39:39 rangi Exp $
 
 #package to deal with Returns
 #written 3/11/99 by address@hidden
@@ -1576,7 +1576,7 @@
                                itemtypes.description AS itemtype,
                                biblioitems.subclass  AS subclass,
                                biblioitems.classification AS classification
-                       FROM issues,items,biblioitems,biblio, itemtypes
+                       FROM issues,items,biblio,biblioitems NATURAL LEFT JOIN 
itemtypes
                        WHERE issues.borrowernumber  = ?
                        AND issues.itemnumber      = items.itemnumber
                        AND items.biblionumber     = biblio.biblionumber