[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: saigonf7q5@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___