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

1 Answer

+4 votes
by
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
by
Super, helped me too :) Thanks.
...