select高级第 1 讲：内连接

一、显式内连接

1.1、定义

        内连接是返回连接表中符合连接条件记录的连接查询

1.2、案例

 SQL：

SELECT newsTitle, topicName 
FROM news AS n 
INNER JOIN topic AS t 
ON n.topicId = t.topicId

二、隐式内连接

SQL：

SELECT newsTitle, topicName 
FROM news AS n, topic AS t 
WHERE n.topicId = t.topicId

 三、脚本下载

编码集：utf8

排序规则：utf8_general_ci

https://download.csdn.net/download/qzc70919700/24227261