AmbiguousOuterJoins.doc (beginner)(2000-2007)

   Please consider donating $1 per sample downloaded, find out why here. 

AmbiguousOuterJoins

The Outer Join can be a powerful tool for querying data in Microsoft Access. When you have only two tables, there is usually no problem. When there are more than two tables, however, using an Outer Join becomes more complicated. Sometimes Access allows it, and sometimes it gives you the not-very-descriptive "Ambiguous Outer Join" error. 

This sample helps demystify this error.
Download
Access 2000+ (79 KB): AmbiguousOuterJoins2k.zip

Author	Message / View First Unread Post Share Topic Printable Version Delicious Digg Facebook Furl Google MySpace Newsvine reddit StumbleUpon Translate Twitter Windows Live Yahoo Bookmarks Topic Search Topic Options Post Reply Create New Topic
Roger Carlson Members Profile Send Private Message Find Members Posts Visit Members Homepage Add to Buddy List Microsoft MVP Joined: 20 Feb 2008 Online Status: Offline Posts: 218	Post Options Post Reply Quote Roger Carlson Report Post Quote Reply Topic: AmbiguousOuterJoins.doc (beginner)(2000-2007) Posted: 04 Aug 2008 at 12:13pm
	Please consider donating $1 per sample downloaded, find out why here. AmbiguousOuterJoins The Outer Join can be a powerful tool for querying data in Microsoft Access. When you have only two tables, there is usually no problem. When there are more than two tables, however, using an Outer Join becomes more complicated. Sometimes Access allows it, and sometimes it gives you the not-very-descriptive "Ambiguous Outer Join" error. This sample helps demystify this error. Download Access 2000+ (79 KB): AmbiguousOuterJoins2k.zip
	Please consider donating $1 per sample downloaded, find out why here.