[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 olwen at katipo.co.nz
@@ -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