SQL Inner Join
Use the SQL INNER JOIN when you only want to return records where there is at least one row in both tables that match the join condition.
Example SQL statement
SELECT * FROM Individual
INNER JOIN Publisher
ON Individual.IndividualId = Publisher.IndividualId
WHERE Individual.IndividualId = 2;
Source Tables
Left Table
IndividualIdFirstNameLastNameUserName1FredFlinstonefreddo2HomerSimpsonhomey3HomerBrownnotsofamous4OzzyOzzbournesabbath5HomerGainnoplacelike
Right Table
IndividualIdAccessLevel1Administrator2Contributor3Contributor4Contributor10Administrator
Result
IndividualIdFirstNameLastNameUserNameIndividualIdAccessLevel2HomerSimpsonhomey2Contributor
Next lesson covers the SQL OUTER JOIN.
