inner join
Database operation that returns rows when there is a match in both tables being joined.
Antonyms: 外部結合
Using an inner join, you get only the data that is common to both tables.
外部結合 (outer join) returns all rows from one table and matched rows from the other, while 内部結合 returns only rows with matches in both tables.
outer join · external coupling; external linkage
Compound of 内部 (internal) and 結合 (join, union), a direct translation of the English computing term 'inner join'.