首先是一张徒弟表follower
然后是一张九阴真经修习层数表kungfu
一共有四个徒弟其中傻姑是没有修习九阴真经的
如果现在我们要 查询所有徒弟的编号、姓名、修习章节、总层数
内连接方式
SELECT
f.`fid` AS '编号',f.`fname` AS '姓名',COUNT(kf.`gid`) AS '修习章节',
SUM(kf.`level`) AS '总层数'
FROM
follower f
INNER JOIN kungfu kf
WHERE
f.`fid` = kf.`fid`
GROUP BY
f.`fid`
左连接方式
SELECT
f.`fid` AS '编号',f.`fname` AS '姓名',COUNT(kf.`gid`) AS '修习章节',
SUM(kf.`level`) AS '总层数'
FROM
follower f
LEFT JOIN kungfu kf
ON f.`fid` = kf.`fid`
GROUP BY
f.`fid`
内连接是把两张表相同的数据查询出来,而左连接是把以左边为基准的数据查询出来