[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[6923] trunk/LedgerSMB/IS.pm

Revision: 6923
Author:   einhverfr
Date:     2014-03-04 07:50:15 +0000 (Tue, 04 Mar 2014)
Log Message:
Correcting join on entity in IS->retrieve_invoice

Modified Paths:

Modified: trunk/LedgerSMB/IS.pm
--- trunk/LedgerSMB/IS.pm	2014-03-03 13:51:46 UTC (rev 6922)
+++ trunk/LedgerSMB/IS.pm	2014-03-04 07:50:15 UTC (rev 6923)
@@ -1936,7 +1936,7 @@
 			          a.on_hold, a.description
 			     FROM ar a
 			LEFT JOIN entity_employee em ON (em.entity_id = a.person_id)
-			INNER JOIN entity e ON e.id = em.entity_id
+			LEFT JOIN entity e ON e.id = em.entity_id
 			    WHERE a.id = ?|;
         $sth = $dbh->prepare($query);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Subversion Kills Productivity. Get off Subversion & Make the Move to Perforce.
With Perforce, you get hassle-free workflows. Merge that actually works. 
Faster operations. Version large binaries.  Built-in WAN optimization and the
freedom to use Git, Perforce or both. Make the move to Perforce.
Ledger-smb-commits mailing list