Match cities to countries?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1181
By Using left oute Join We can do

Syntax:
SELECT b.COUNTRY, b.CITY_NAME, Area
FROM Countries a
LEFT OUTER JOIN Cities b
ON CITIES.COUNTRY_CODE = a.COUNTRY_CODE
WHERE area= 'Asia'

Comments or Responses

Login to post response