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

[..hidden..]

Revision: 6923
          http://sourceforge.net/p/ledger-smb/code/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:
--------------
    trunk/LedgerSMB/IS.pm

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.
http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits