0

Please login or register to vote for this query.

(click on this box to dismiss)

Show all values in known tables that map a type id to a type name.

Q&A about the site for gardeners and landscapers

select
  q.Id,a.CreationDate
from
  Posts q
 inner join 
  Posts a
  on q.Id = a.ParentId and a.postTypeId = 2 and q.postTypeId = 1
where
  a.OwnerUserId = q.Id
order by q.Id

fork query

edited nov 8 19 anonymous

created jun 2 11 Gilles