SF.net SVN: ledger-smb:[3642] trunk/sql/modules/Payment.sql

[..hidden..]

Revision: 3642
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3642&view=rev
Author:   einhverfr
Date:     2011-08-06 01:49:51 +0000 (Sat, 06 Aug 2011)

Log Message:
-----------
Correcting bug 3386822

Modified Paths:
--------------
    trunk/sql/modules/Payment.sql

Modified: trunk/sql/modules/Payment.sql
===================================================================
--- trunk/sql/modules/Payment.sql	2011-08-06 01:36:44 UTC (rev 3641)
+++ trunk/sql/modules/Payment.sql	2011-08-06 01:49:51 UTC (rev 3642)
@@ -1215,7 +1215,8 @@
    SELECT p.id as payment_id, p.reference as payment_reference, p.payment_date,  
           c.legal_name as legal_name, am.amount as amount, em.first_name, em.last_name, p.currency, p.notes
    FROM payment p
-   JOIN employee em ON (em.entity_id = p.employee_id)
+   JOIN entity_employee ent_em ON (ent_em.entity_id = p.employee_id)
+   JOIN person em ON (ent_em.entity_id = em.entity_id)
    JOIN entity_credit_account eca ON (eca.id = p.entity_credit_id)
    JOIN company c ON   (c.entity_id  = eca.entity_id)
    JOIN payment_links pl ON (p.id = pl.payment_id)


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