outer join issues

J

John T Ingato

I hope I can explain this well enough. I am new to Access.
I have a tble of 1800 stores, a table of Inventory levels for each week, and
a table of 10 products.

***tblStores***
StoreNumber
address

***tblInventoryData***
StoreNumber
ItemNumber

***tblProducts***
ItemNumber

I would like to perform a query that will be sure to include every store in
the stores table AND every product in the products table. Unfortunately, the
sales reports are not always complete and certain items just do not show up.
Obviously this is inconsistant.

I tried using outer join from stores to sales data AND an outer join from
products to sales data but I get an error stating ambiguous outer joins.

I am confused. Can someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A bug in GUI of creating query with more outer joins between two tables 5
Ambiguous outer join 6
Pulling data out and understanding total queries 3
Relationship - Outer Join - Microsoft Access 2002 1
have productids that don't have sales & saleof products not on pro 3
Outer Join Query issues 1
Help Disambiguate my Join 2
OUTER join problem 8

Top