Source Code Create a value with Confidence...
Inner Join
Description :
an inner join consists of the INNER JOIN keyword, which specifies which two tables are to be joined. After the INNER JOIN keyword, you specify an ON clause, which identifies the condition that must be true for a row from each table to be included in the final joined results. The basic syntax of an inner join is as follows:

Syntax :
name_of_table_on_left INNER JOIN name_of_table_on_right ON condition

Example :
SELECT MeetingDate, FirstName, LastName FROM Attendance INNER JOIN MemberDetails ON Attendance.MemberId = MemberDetails.MemberId;

Output : MeetingDate FirstName LastName 2004-01-01 Katie Smith 2004-01-01 John Jones