SF.net SVN: ledger-smb: [1540] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 1540
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=1540&view=rev
Author:   einhverfr
Date:     2007-09-07 20:54:36 -0700 (Fri, 07 Sep 2007)

Log Message:
-----------
Correcting customer/vendor views

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2007-09-08 02:32:58 UTC (rev 1539)
+++ trunk/sql/Pg-database.sql	2007-09-08 03:54:36 UTC (rev 1540)
@@ -489,7 +489,7 @@
         ein.note as invoice_notes 
     FROM entity_credit_account emd 
     join entity_bank_account eba on emd.entity_id = eba.entity_id
-    join entity_note ein on ein.ref_key = emd.entity_id
+    Left join entity_note ein on ein.ref_key = emd.entity_id
     join company c on c.entity_id = emd.entity_id
     where emd.entity_class = 2;
     
@@ -517,7 +517,7 @@
         invoice_notes 
     FROM entity_credit_account emd 
     join entity_bank_account eba on emd.entity_id = eba.entity_id
-    join entity_note ein on ein.ref_key = emd.entity_id
+    left join entity_note ein on ein.ref_key = emd.entity_id
     join company c on c.entity_id = emd.entity_id
     where emd.entity_class = 1;
 


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