• The INNER JOIN keyword retrieves records with matching values in both tables.

SELECT column_name(s)
FROM table1;
INNER JOIN table2;
ON  table1.column_name = table2.column_name;

• Here is a portion from the "Wikitechy" table:

• Here is an excerpt from the " Student Detail " table:

SELECT tbl_Wikitechy.Student_Id, tbl_Wikitechy.Student_Name, tbl_Student_Detail.Place
FROM tbl_Wikitechy
INNER JOIN tbl_Student_Detail
ON  tbl_Wikitechy.Student_Id = tbl_Student_Detail.Student_Id;