sql select语句如何连接表

sql

小樊

110

2024-07-26 19:00:10

栏目: 云计算

在 SQL 中连接表可以使用 JOIN 关键字来实现。常用的连接方式有：

SELECT * 
FROM table1
INNER JOIN table2
ON table1.column = table2.column;

SELECT * 
FROM table1
LEFT JOIN table2
ON table1.column = table2.column;

SELECT * 
FROM table1
RIGHT JOIN table2
ON table1.column = table2.column;

SELECT * 
FROM table1
FULL JOIN table2
ON table1.column = table2.column;

还可以使用子查询或者关联子查询来连接表：

SELECT *
FROM table1
WHERE column IN (SELECT column FROM table2);

最新问答