JOIN Error...Need a little help

[helpme07]

Hi Everyone,

I'm trying to create a list for suppliers and customers. However I receive "The multi-part identifier "Suppliers.Supp lierID" could not be bound"

Select Suppliers.Compa nyName, Suppliers.Addre ss, CompanyName.c1, c1.Address From Customers c1
INNER JOIN ProductsCopy on ProductsCopy.Su pplierID = Suppliers.Suppl ierID
INNER JOIN [Order Details] on [Order Details].ProductID = ProductCopy.Pro ductID
INNER JOIN Orders on Orders.OrderID = [Order Details].OrderID
INNER JOIN Customers on Customers.Custo merID = Orders.Customer ID

Running MS SQL Server 2005

[helpme07]

***Sorry it should be c1.CompanyName

[Shashi Sadasivan]

where is the Suppliers table being selected from in that query?

cheers :)