By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,188 Members | 834 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,188 IT Pros & Developers. It's quick & easy.

Getting data from Sage Account

P: n/a
I am trying to make sense of the Sage Line 50 accounts package through
Access 2k
I have linked the tables and they appear OK

The following query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON AUDIT_JOURNAL.NOMINAL_CODE
= NOMINAL_LEDGER.ACCOUNT_REF) INNER JOIN PURCHASE_LEDGER ON
AUDIT_JOURNAL.ACCOUNT_REF = PURCHASE_LEDGER.ACCOUNT_REF;

but if I change the equal join between the Audit_Journal and the Purchase
ledger from an inner join to a left join thus

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON AUDIT_JOURNAL.NOMINAL_CODE
= NOMINAL_LEDGER.ACCOUNT_REF) LEFT JOIN PURCHASE_LEDGER ON
AUDIT_JOURNAL.ACCOUNT_REF = PURCHASE_LEDGER.ACCOUNT_REF;

I get an error
"Could not execute query, could not find linked table Table not found
(#0)"

However this query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
PURCHASE_LEDGER.NAME
FROM AUDIT_JOURNAL LEFT JOIN PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;

Any ideas please

Thanks

Phil
Sep 6 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Phil Stanton" <ph**@myfamilyname.co.ukwrote in message
news:c4******************************@posted.plusn et...
>I am trying to make sense of the Sage Line 50 accounts package through
Access 2k
I have linked the tables and they appear OK

The following query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON
AUDIT_JOURNAL.NOMINAL_CODE = NOMINAL_LEDGER.ACCOUNT_REF) INNER JOIN
PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;

but if I change the equal join between the Audit_Journal and the Purchase
ledger from an inner join to a left join thus

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
NOMINAL_LEDGER.NAME, PURCHASE_LEDGER.NAME
FROM (AUDIT_JOURNAL INNER JOIN NOMINAL_LEDGER ON
AUDIT_JOURNAL.NOMINAL_CODE = NOMINAL_LEDGER.ACCOUNT_REF) LEFT JOIN
PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF =
PURCHASE_LEDGER.ACCOUNT_REF;

I get an error
"Could not execute query, could not find linked table Table not found
(#0)"

However this query runs OK

SELECT AUDIT_JOURNAL.NOMINAL_CODE, AUDIT_JOURNAL.ACCOUNT_REF,
PURCHASE_LEDGER.NAME
FROM AUDIT_JOURNAL LEFT JOIN PURCHASE_LEDGER ON AUDIT_JOURNAL.ACCOUNT_REF
= PURCHASE_LEDGER.ACCOUNT_REF;

Any ideas please

Thanks

Phil
PS Seems to work OK If I Import tables rather than linking them
>

Sep 6 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.