From e964c302d019f30476b62c6111f05e6ca9d966fe Mon Sep 17 00:00:00 2001 From: einhverfr Date: Sat, 8 Sep 2007 03:54:36 +0000 Subject: Correcting customer/vendor views git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@1540 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/Pg-database.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/sql/Pg-database.sql b/sql/Pg-database.sql index 39c08f4c..d4df3ea5 100644 --- a/sql/Pg-database.sql +++ b/sql/Pg-database.sql @@ -489,7 +489,7 @@ CREATE VIEW customer AS 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 @@ CREATE VIEW vendor 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 = 1; -- cgit v1.2.3