Skip to content

JOIN

一句话解释

JOIN 组合行 从 two or 更多表 based on 条件 — 通常 matching 外键到 主键.

用大白话说

JOIN 组合数据从 two 表到 单个 result 设置. 大多数常见模式是 matching 外键 in one 表到 主键 in another — 例如, 合并 orders 到 users on orders.user_id = users.id to see who placed each order.

There are several types of joins:

  • INNER JOIN: only rows that match in both tables.
  • LEFT JOIN: all rows from the left table, plus matches from the right (NULL if no match).
  • RIGHT JOIN: all rows from the right table, plus matches from the left.
  • FULL OUTER JOIN: all rows from both tables, matched where possible.

Joins are powerful but can be expensive on large tables. Always join on indexed columns when possible.

示例

sql
-- Find each order with the user's name
SELECT orders.id, users.name, orders.total
FROM orders
INNER JOIN users ON orders.user_id = users.id;

INNER JOIN matches 每个顺序到 它的用户, 组合列 从两者都表.

相关术语

相关资源

相关课程

  • 连接

    学习如何 组合数据从 多个表.

解读错误信息

用大白话解释常见错误——什么意思、为什么发生、如何修复。

查看错误

← 返回术语表