July 7th, 2000, 11:31 AM
Join Date: Jun 2000
Time spent in forums: < 1 sec
Reputation Power: 0
Hello, I currently have a working Inner Join statment.
My main Table is called "Item" I then plug values from Tables "Category" and "Department"
I would like to plug in values from an additional Table to exchange a "Item.SupplierID" with the "Supplier.SupplierName"
Here is my current query:
Inner Join (Category Inner Join Department ON Category.DepartmentID=Department.ID) ON Item.CategoryID = Category.ID
Where Department.Name = 'Pets'
Group by Category.Name,Department.Name,Item.Description,Item.Price,Item.ID
I tried simply adding the additional Join:
... Inner Join (Category Inner Join (Department Inner Join ( .... ))
But that did not work.
The Supplier table is not related to the Department and Category Tables.
I am using NT4.0, ODBC, Access97 data.
Thanks for the help. Please ask if more information is required here.