SELECT * FROM PostTypes INNER JOIN ( SELECT postTypeID F...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT * FROM PostTypes 
INNER JOIN
 (
SELECT  postTypeID FROM users users 
inner join Posts Post
on users.id=Post.OwnerUserId
WHERE
displayName='Mat Mannion'
) AS postTypeID_peruser
ON PostTypes.ID = postTypeID_peruser.postTypeID

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results