[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[6548] branches/1.3/sql/upgrade/sl2.8-1.3.sql

Revision: 6548
Author:   ehuelsmann
Date:     2014-01-19 11:46:31 +0000 (Sun, 19 Jan 2014)
Log Message:
Backport the fixes part of r6547.

Revision Links:

Modified Paths:

Modified: branches/1.3/sql/upgrade/sl2.8-1.3.sql
--- branches/1.3/sql/upgrade/sl2.8-1.3.sql	2014-01-19 11:44:48 UTC (rev 6547)
+++ branches/1.3/sql/upgrade/sl2.8-1.3.sql	2014-01-19 11:46:31 UTC (rev 6548)
@@ -475,15 +475,19 @@
        JOIN account a ON (a.accno = c.accno);
 INSERT INTO eca_tax (credit_id, chart_id)
-  SELECT credit_id, (select id from account
+  SELECT c.credit_id, (select id from account
                       where accno = (select accno from sl28.chart sc
                                       where sc.id = ct.chart_id))
    FROM sl28.customertax ct
+   JOIN sl28.customer c
+     ON ct.customer_id = c.id
-  SELECT credit_id, (select id from account
+  SELECT v.credit_id, (select id from account
                       where accno = (select accno from sl28.chart sc
                                       where sc.id = vt.chart_id))
-   FROM sl28.vendortax vt;
+   FROM sl28.vendortax vt
+   JOIN sl28.vendor v
+     ON vt.vendor_id = v.id;

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

CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today.
Ledger-smb-commits mailing list