0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT DISTINCT u.Id,
       u.DisplayName,
       p.OwnerUserId,
       c.UserId
FROM Users AS u
LEFT OUTER JOIN  Posts AS p ON u.Id = p.OwnerUserId
LEFT OUTER JOIN Comments AS c ON u.Id = c.UserId;

view current version

edited jun 4

created jun 4 jon.doe42064