Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
in Q2A Core by
I want to access the best answers from the database for all the questions.

1 Answer

+4 votes
selected by
Best answer

I guess this should do:

SELECT a.* FROM qa_posts q
JOIN qa_posts a ON q.selchildid = a.postid
No need to filter by answers as they are the only one linked as the selchildid
Super, helped me too :) Thanks.