Code Snippet posted by:
Sabarimahesh | Posted on: 4/19/2012 | Category:
SQL Server Codes | Views: 427 | Status:
[Member] |
Points: 40
|
Alert Moderator
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'
Life is a Race
Thanks & Regards
By
Sabari Mahesh P M