Sunday 6 October 2013

08. Write a query to display all the country region codes along with their corresponding territory IDs.

select c.CountryReglonCode, territoryID
from sales.salesTerritory s
Right Outer join sales.CountryReglonCurrecy c
on s.CountryReglonCode = c.CountryReglonCode

No comments:

Post a Comment