0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientific skepticism

SELECT
    DISTINCT U.UserId AS UserID,
    P.Id AS PostID,
    T.TagName AS PostTag
FROM
    (
        SELECT
            UserId,
            PostId
        FROM
            Comments
    
        UNION
    
        SELECT
            OwnerUserId AS UserId,
            Id AS PostId
        FROM
            Posts
    ) U
JOIN
    Posts P ON U.PostId = P.Id
JOIN
    PostTags PT ON P.Id = PT.PostId
JOIN
    Tags T ON PT.TagId = T.Id;

view current version

edited nov 29 23

created nov 29 23 anonymous