MS Access Inner Join on Multiple Fields and Conditions

Ms Access inner join function is another SQL Join function, but unlike Left and Right Join, it will return only the records with matching value from both joined or multiple tables with several conditions. For better understanding on this function, look at the picture: Using Inner Join, the returned result will be “C”.   The

source http://database.access-templates.com/ms-access-inner-join-on-multiple-fields-and-conditions.html