0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

DECLARE @UserId int = ##UserId##;

SELECT 
  Answers.*,
  Votes.*
FROM 
  Posts AS Answers
  LEFT JOIN Votes ON (Answers.Id = Votes.PostId)
WHERE 
  Answers.OwnerUserId = @UserId AND 
  Answers.PostTypeId = 2;

fork query

edited aug 22 17 Martin.Parenteau

created mar 24 14 Eric Koleda