inner join
collocation内连接（只返回两表中匹配行的连接）
An inner join returns only the rows that exist in both tables.
内连接只返回同时存在于两个表中的行。
连接处；接合点；接缝
joins — plural of join
先理解核心含义，再看它在真实句子里的用法。
连接处；接合点；接缝
a place where two things are joined, or the act of joining; a junction
The carpenter carefully sanded the join to make it smooth.
木匠仔细打磨了接合处使其光滑。
连接或结合的行为或状态；接合点或连接。
An act of joining or the state of being joined; a junction or joining.
连接处；接合方式
the shape or manner in which things come together and a connection is made
管道或线路的交叉点；互连。
An intersection of piping or wiring; an interconnect.
并集；包含两个或更多集合所有成员的集合
a set containing all and only the members of two or more given sets
In set theory, the join of two sets is the set of all elements that belong to either set.
在集合论中，两个集合的并集是包含任一集合中所有元素的集合。
The plumber applied sealant to the join between the two pipes.
水管工在两管之间的连接处涂了密封剂。
Choose the next layer that will help you use joins with more confidence.
Recommended next
Missing: Usage patterns
Complete this area with usage patterns.
Includes Common mistakes & Confusing words
See typical errors learners make and confusing words to avoid.
Focus on the distinctions below. Other candidates are kept compact until a reliable usage note is available.
内连接（只返回两表中匹配行的连接）
An inner join returns only the rows that exist in both tables.
内连接只返回同时存在于两个表中的行。
左连接（返回左表全部行及右表匹配行的连接）
A left join gives you every row from the left table and only matching rows from the right table.
左连接返回左表的每一行以及右表中匹配的行。
右连接（返回右表全部行及左表匹配行的连接）
A right join is like a left join but keeps all rows from the right table.
右连接与左连接类似，但保留右表中的所有行。
全连接（返回两表中所有行的连接）
A full join returns all rows from both tables, filling in missing matches with nulls.
全连接返回两个表中的所有行，缺失的匹配项用空值填充。
交叉连接（两表所有行的笛卡尔积）
A cross join pairs each row in one table with every row in the other table.
交叉连接将一个表中的每一行与另一个表中的每一行进行配对。
连接条件（控制两表如何匹配的规则）
The join condition determines which rows are combined.
连接条件决定哪些行会被合并。
如果你不能打败他们，就加入他们。
A common English proverb advising that if you cannot defeat an opponent, it is wiser to join forces with them.
常见的英语谚语，意思是如果无法打败对手，不妨与对方合作。
加入或死亡。
A famous political cartoon by Benjamin Franklin (1754) urging the American colonies to unite against British rule; later used as a patriotic slogan.
本杰明·富兰克林1754年的著名政治漫画，呼吁北美殖民地联合起来对抗英国统治；后来成为爱国口号。
Use joins naturally, then get feedback on meaning, tone, grammar, and phrasing.
Revisit a common error or keep this word in your review list.
join 开头的 j 像一个钩子，把两边钩在一起，就是“连接处”。
语域：neutral 常见场景：woodworking/construction、plumbing/electrical wiring、mathematics/computer science 作名词的 join 多用于描述两个事物相接的位置或方式，常见于木工、建筑、管道、电路等技术语境；在数学/计算机领域中还可指“并集”或“连接”。日常口语中较少单独使用，通常可根据上下文理解为“接缝/接头”。
作为名词时，通常与介词 between 或 of 连用。
Dictionary facts from DICTIONARY_API_DEV, ECDICT, WIKTIONARY.