Phucon,
Please tell us what you mean by "causes an outer join to fail". Is it taking too long to run or returning the wrong results?
Can you provide any details about the "faraway server"?
Are the tables in Access or SQL Server?
Can you provide the SQL statement and information about which fields are indexed?
How many records in each table?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 9 Sep 2014 10:45:54 -0700
Subject: [MS_AccessPros] What causes an outer join fail to work when use with remote tables?
I have a Left Join query which's joining 2 remote (link) tables that reside somewhere in a faraway server.
The query result's never been an outer join, it only displays the matching records and dropped the records that don't match.I was told that only a full outer join can get the correct result, and full join won't work in Access. I was told to use the Make Table Query, change the query to 2 local tables then re-join them. That worked! What causes an outer join fail to work when use with remote tables? Phucon
Please tell us what you mean by "causes an outer join to fail". Is it taking too long to run or returning the wrong results?
Can you provide any details about the "faraway server"?
Are the tables in Access or SQL Server?
Can you provide the SQL statement and information about which fields are indexed?
How many records in each table?
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Tue, 9 Sep 2014 10:45:54 -0700
Subject: [MS_AccessPros] What causes an outer join fail to work when use with remote tables?
I have a Left Join query which's joining 2 remote (link) tables that reside somewhere in a faraway server.
The query result's never been an outer join, it only displays the matching records and dropped the records that don't match.I was told that only a full outer join can get the correct result, and full join won't work in Access. I was told to use the Make Table Query, change the query to 2 local tables then re-join them. That worked! What causes an outer join fail to work when use with remote tables? Phucon
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar