Get all countries and corresponding cities?

Sabarimahesh
Posted by Sabarimahesh under Sql Server category on | Points: 40 | Views : 1311
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

Comments or Responses

Login to post response