Query Help - ambiguous outer join

**jammy1812** · 10-18-2012, 06:45 AM

Hi guys,
I'm currently doing some coursework and can't get my head around a query..

I have a database, with 9 entities and I need to pull information off of 5 of them to create a customer invoice in Excel.

As it's to do with customer orders, etc. it needs to be linked, but when I try to run the query I get an ambiguous outer join error.

The 5 entities are:

Member Details (Holds, names, IDs, etc.)
Address Details (Holds member address)
Member Order (Order details of members)
Order Line (Order details of product and member order)
Product (Product details)

Wondering if anyone can help me with this?

I have tried breaking the relationships, but I get hundreds of results, when i should only be a few dozen.

Thanks..

**alansidman** · 10-18-2012, 07:27 AM

Post your current SQL statement or upload your db for analysis. Can't help until we understand how your tables are joined.

**jammy1812** · 10-18-2012, 08:23 AM

Hi,

I can't seem to upload the database file, how do I produce an SQL statement? I'm using Access 2010.
Thanks.
=)

**alansidman** · 10-18-2012, 09:43 AM

With your query open in QBE, look up to the left corner of the ribbon while on the Home tab. You will see a small Icon that looks like a spreadsheet. Next to it is a dropdown arrow. Select the arrow and then select SQL. An SQL window will open. Copy your SQL statement and paste it into a thread. Make sure to use the code tags.

Alan