SF.net SVN: ledger-smb:[3975] trunk/LedgerSMB/PE.pm

[..hidden..]

Revision: 3975
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3975&view=rev
Author:   ehuelsmann
Date:     2011-11-10 21:23:47 +0000 (Thu, 10 Nov 2011)
Log Message:
-----------
Fix query (bug 3435751 - found by haso on irc.

Modified Paths:
--------------
    trunk/LedgerSMB/PE.pm

Modified: trunk/LedgerSMB/PE.pm
===================================================================
--- trunk/LedgerSMB/PE.pm	2011-11-10 15:30:24 UTC (rev 3974)
+++ trunk/LedgerSMB/PE.pm	2011-11-10 21:23:47 UTC (rev 3975)
@@ -1838,9 +1838,8 @@
 		          p.partnumber
 		     FROM jcitems j
 		     JOIN project pr ON (pr.id = j.project_id)
-		     JOIN employee e ON (e.id = j.employee_id)
 		     JOIN parts p ON (p.id = j.parts_id)
-		LEFT JOIN entity_credit_account eca ON (c.id = pr.credit_id)
+		LEFT JOIN entity_credit_account eca ON (eca.id = pr.credit_id)
                 LEFT JOIN company c ON eca.entity_id = c.entity_id
 		    WHERE pr.parts_id IS NULL
 		          AND j.allocated != j.qty $where

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