***Sorry it should be c1.CompanyName

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...