Your team needs

a list of all your suppliers, their full delivery address, and

the name of both the primary and alternate contacts for the

supplier. Order the results by supplier name.

We need the following tables - Purchasing.Suppliers, and

the People, Cities, and StateProvinces tables in the Application

schema. The columns to join things up are a bit more tricky -

- Suppliers to people on the PersonID and the PrimaryContactPersonID

or AlternateContactPersonID.

- Cities on CityID to Suppliers on DeliveryCityID

- StateProvices on StateProvinceID (on both sides)

* can join to the same table multiple times

as long as we give them different aliases

example output with the columns and one row

SupplierName PrimaryContactName AlternateContactName DeliveryAddressLine1 DeliveryAddressLine2 DeliveryCityID CityName StateProvinceCode DeliveryPostalCode

A Datum Corporation Reio Kabin Oliver Kivi Suite 10 183838 Southwest Boulevard 38171 Zionsville IN 46077