在 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);
亿速云「云服务器」,即开即用、新一代英特尔至强铂金CPU、三副本存储NVMe SSD云盘,价格低至29元/月。点击查看>>
推荐阅读:SQL中concat如何简化SQL语句