RIGHT OUTER JOIN Syntax
SELECT YourColumnName FROM YourTableName
RIGHT OUTER JOIN InnerTableName ON InnerTableName.Column = YourTableName.Column
Example
SELECT * FROM City
RIGHT JOIN Country ON Country.CountryID = City.CountryIDF
OR
SELECT * FROM City
RIGHT OUTER JOIN Country ON Country.CountryID = City.CountryIDF
SELECT YourColumnName FROM YourTableName
RIGHT OUTER JOIN InnerTableName ON InnerTableName.Column = YourTableName.Column
Example
SELECT * FROM City
RIGHT JOIN Country ON Country.CountryID = City.CountryIDF
OR
SELECT * FROM City
RIGHT OUTER JOIN Country ON Country.CountryID = City.CountryIDF
No comments:
Post a Comment