0

Please login or register to vote for this query.

(click on this box to dismiss)

(the extreme self-learners)

Q&A for professionals and students of engineering

SELECT 
    q.Id as QuestionId,
    a.Id as AnswerId,
    q.Title,
    q.Score as QuestionScore,
    a.Score as AnswerScore
FROM
    Posts q
  INNER JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
  INNER JOIN
    Users ON Users.Id = q.OwnerUserId
  --INNER JOIN
    
WHERE 
    q.OwnerUserId = a.OwnerUserId and Users.Id = 505893

fork query

edited apr 4 12 rumoreblu

created may 31 10 balusc