0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for people interested in governments, policies, and political processes

SELECT Top 2 
q.id, q.Title, q.Body q_body, q.parentid qpid, q.AcceptedAnswerId, 
q.Score q_score, q.AnswerCount, q.Tags, q.viewcount,

answers.parentid aa_pid, answers.id aa_id, answers.body aa_body,
answers.score as aa_score, answers.posttypeid 

FROM 
  Posts answers

INNER JOIN Posts q 
  ON answers.parentid = q.id
 
WHERE (answers.id = q.AcceptedAnswerId)

fork query

edited may 31 Musenga

created oct 29 19 anonymous