Inner Join (SQL)

Inner Join (INNER JOIN): tuple is included in the result only if a matching tuple exists in the other relation (this is the default type of JOIN)