正如标题所说,我想要一个解决方法......
SELECT
comments.comment_id,
comments.content_id,
comments.user_id,
comments.`comment`,
comments.comment_time,
NULL
FROM
comments
WHERE
(comments.content_id IN (SELECT content.content_id FROM content WHERE content.user_id = 1 LIMIT 0, 10))
Cheers
SELECT comments.comment_id,
comments.content_id,
comments.user_id,
comments.`comment`,
comments.comment_time,
NULL
FROM (
SELECT content.content_id
FROM content
WHERE content.user_id = 1
LIMIT 10
) q
JOIN comments
ON comments.content_id = q.content_id
您可能想要添加一个ORDER BY
进入嵌套查询。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)