Multi Table Query Help

[just4plaay]

I have a Vendor List, product list and a vendor item list as shown below. I need a query that will create a product list that has the current vendors price and bundle quantity. Unfortunately, I'm not getting the results I need instead I'm getting a product list that has duplicate products, one per vendor item regardless of whether they are the preferred vendor.

Product List

ID	Code	Description	Current Vendor
1	1006	Flat Sheets	3, ADI
2	1028	Bath Blankets	2, Medline
3	1070	Blue Bags	3, ADI

Vendor Item List

ID	Vendor Item Code	Company Product Code	Price	Bundle Qty	Vendor
1	STFLATBLK	1006	1.12	300	3, ADI
2	T180BLU	1028	1.54	200	2, Medline
3	TFLTWHT	1006	1.14	350	3, ADI
4	BLUBGS	1070	1.63	600	2, Medline
5	1532BLU	1070	1.1	300	3, ADI

Vendors

Code	Vendor Name	Contact	Billing
1	Standard Text	Dick	Oregon
2	Medline	Charly	St Paul
3	ADI	Kevin	Denver

What I need to get out of it is the following

Product Code	Vendor	Vendor Product Code	Bundle Size	Price
1006	3, ADI	1, STDFLATBLK	300	1.12
1028	2, Medline	2, T180BLU	200	1.54
1070	3, ADI	5, 1532BLU	300	1.1

[aytee111]

Join Product List to Vendor Item List on Code and Current Vendor.

[just4plaay]

Join Product List to Vendor Item List on Code and Current Vendor.

When I attempt to do this in the query relationships it errors saying "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query that performs the first join and then include that query in your SQL statement.

[aytee111]

All of the joins should be inner joins, unless your data can be missing?