0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people studying math at any level and professionals in related fields

select * 
from Posts as p
join PostTypes as pt on p.PostTypeId=pt.Id 
join Users as u on p.OwnerUserId =u.Id
where u.DisplayName = 'Mat Mannion' and pt.Name = 'Question'

--OwnerUserId=6282 and PostTypeId=1

--Select * from PostTypes where Name='Question'

--select * from Users where DisplayName='Mat Mannion'

fork query

edited dec 3

created dec 3 anonymous