0

Please login or register to vote for this query.

(click on this box to dismiss)

That field versus what the user's display name is actually set to.

Q&A for anime and manga fans

-- OwnerDisplayName
-- That field versus what the user's display name is actually set to.

select top 100
    p.Id as [Post Link],
    u.Id as [User Link],
    p.OwnerDisplayName as [Posted As],
    u.DisplayName as [Actual Name]
from Posts as p
join Users as u on p.OwnerUserId = u.Id
where p.OwnerDisplayName != u.DisplayName

fork query

created may 8 11 PleaseStand