Get all countries and corresponding cities?

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

By Using Right Outer Join

We can Do

Syntax

SELECT a.COUNTRY, b.CITY_NAME 
FROM CITIES b
RIGHT OUTER JOIN COUNTRIES a
ON b.COUNTRY_CODE = a.COUNTRY_CODE

Bookmark It

Latest Code Snipptes