Wednesday, 20 January 2010

AmbiguousOuterJoins.doc ( beginner )

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.




Download

Access 2000 (79 KB): AmbiguousOuterJoins2k.zip

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Receipt Management: Stop Losing Paper Receipts Forever

Paper receipts fade, tear, and get lost. Here's how the Petty Cash app solves the receipt problem permanently. The Paper Problem Therma...

  • AppendValuesToExcel.mdb (intermediate)
    This sample demonstrates how to append data from a database to an Excel Spreadsheet using Office Automation to find the next empty row in th...
  • Microsoft Office Access 2007
    Microsoft Office Access , previously known as Microsoft Access , is a relational database management system from Microsoft that combines t...