SELECT TOP 200 p.[Title] , p.[Body] , p.[Tags] , p2.[Scor...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT TOP 200
      p.[Title]
      , p.[Body]
      , p.[Tags]
      , p2.[Score] AS AnswerScore
      , p2.[Body] AS AnswerBody
      , p2.[CreationDate] AS AnswerCreationDate
      , p2.[OwnerDisplayName] AS AnswerUserName
      , p2.[Id] AS AnswerId
      --, p.* 
FROM [Posts] p
JOIN [Posts] p2 ON p.[AcceptedAnswerId] = p2.[Id]
WHERE p.[AcceptedAnswerId] IS NOT NULL

Enter Parameters

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