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