更新时间:2023-08-25 23:13:40
使用双JOIN.
JOIN
SELECT id FROM blogPosts p INNER JOIN blogPostToTags pt1 ON pt1.id = p.id INNER JOIN blogPostToTags pt2 ON pt2.id = p.id WHERE pt1.tagId = 1 AND pt2.tagId = 2;
如何选择与所有必需标签匹配的帖子?