0

Please login or register to vote for this query.

(click on this box to dismiss)

posts q left join users u on q.OwnerUserId=u.id where q.id=37449

Q&A for computer enthusiasts and power users

--select q.*, u.* from 
--posts q left join users u on q.OwnerUserId=u.id
--where q.id=37449

select OwnerDisplayNameCased = case q.OwnerDisplayName when null then 'Null' else 'NotNull' end, 
OwnerDisplayName
from posts q where q.id=37449

fork query

created may 26 10 randolpho