SELECT DISTINCT u.Id, u.DisplayName FROM Users AS u LEFT ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy

Q&A for science fiction and fantasy enthusiasts

SELECT DISTINCT u.Id,
       u.DisplayName
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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results