Mysql如何限制left join结果

Question

我有两个表:歌曲和组

我想限制歌曲匹配组为 3

我试过这个:

SELECT
groups.`IDgroup`,
groups.`name` AS g_name,
songs.`IDsong`,
songs.`name` AS s_name
FROM  `groups` 
LEFT OUTER JOIN songs ON (groups.`IDgroup` = songs.`IDgroup` LIMIT 3)

Answer 1

将 limit 放在括号外:

SELECT
groups.`IDgroup`,
groups.`name` AS g_name,
songs.`IDsong`,
songs.`name` AS s_name
FROM  `groups` 
LEFT OUTER JOIN songs 
ON groups.`IDgroup` = songs.`IDgroup` 
LIMIT 3