具有多个联接的SQL语句

SELECt *
FROM

Post

AS

p

LEFT JOIN

CategoryBinding

AS

cb

ON p.ID = cb.postID
LEFT JOIN

Category

AS

c

ON cb.categoryID = c.ID
INNER JOIN

Post

AS

p2

ON p.id = p2.id
WHERe p.id in
(
SELECt p2.id
FROM

Post

as

p2

LEFT JOIN

CategoryBinding

AS

cb

ON p2.ID = cb.postID
LEFT JOIN

Category

AS

c

ON cb.categoryID = c.ID
WHERe c.id = @SomeCategory
)

好了，最后一枪。

这将返回重复的行，只需将一个group by添加到您想要的任何内容。