From 87ca70bacd544f1b027cb640e9caed28323f5c8b Mon Sep 17 00:00:00 2001 From: einhverfr Date: Wed, 6 Aug 2008 17:12:46 +0000 Subject: Correcting join problem when pulling up existing AP Transactions git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2233 4979c152-3d1c-0410-bac9-87ea11338e46 --- LedgerSMB/Form.pm | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm index 9883839c..3d43b8a6 100644 --- a/LedgerSMB/Form.pm +++ b/LedgerSMB/Form.pm @@ -2248,7 +2248,8 @@ sub create_links { c.language_code, a.ponumber, a.reverse, a.approved FROM $arap a - JOIN entity_credit_account c USING (entity_id) + JOIN entity_credit_account c + ON (a.entity_credit_account = c.id) JOIN entity ce ON (ce.id = c.entity_id) LEFT JOIN employee er ON (er.entity_id = a.person_id) LEFT JOIN entity e ON (er.entity_id = e.id) -- cgit v1.2.3