SQL中的JOIN类型解释（CROSS, INNER,OUTER），关键字ON,USING

分类: 文章 • 2024-02-22 08:26:28

书上讲得明白，解了不少迷惑。

SELECT e.fname, e.lname, d.name  FROM employee AS e INNER JOIN department AS d ON e.dept_id = d.dept_id;

SELECT e.fname, e.lname, d.name  FROM employee AS e INNER JOIN department AS d USING (dept_id);

SQL中的JOIN类型解释（CROSS, INNER,OUTER），关键字ON,USING