Sunday 6 October 2013

02. Write a query to display the sales person ID of all the sales persons and the name of the territory to which they belong.

select salespersonID, Name
from sales.salesPerson
join sales.salesterritory
on salesperson.territoryID = salesTeriitory.TerritoryID

No comments:

Post a Comment