Match cities to countries?

Posted by Sabarimahesh under Sql Server category on 4/19/2012 | Points: 40 | Views : 2172

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'

Bookmark It

Latest Code Snipptes