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 (SELECT OwnerUserId
                 FROM Posts
                 WHERE OwnerUserId IS NULL) AS p ON u.Id = p.OwnerUserId
LEFT OUTER JOIN (SELECT UserId
                 FROM Comments
                 WHERE UserId IS NULL) AS c ON u.Id = c.UserId
ORDER BY u.Id

view current version

edited jun 4

created jun 4 jon.doe42064