Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Remember

How are questions and best answers for them stored in db?

+1 vote

6.3k views

asked Aug 26, 2014 in Q2A Core by mukul_shrm

I want to access the best answers from the database for all the questions.

Please log in or register to add a comment.

+4 votes

answered Aug 26, 2014 by pupi1985
selected Aug 26, 2014 by mukul_shrm

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

commented Dec 3, 2015 by offline

Super, helped me too :) Thanks.

Welcome to the Q&A site for Question2Answer.

If you have a question about Q2A, please ask here, in English.

To report a bug, please create a new issue on Github or ask a question here with the bug tag.

If you just want to try Q2A, please use the demo site.