MYSQL comments for each post
How do sites like stackoverflow.com use a query to get all answers from the answers table and get all the comments associated with the answer. Also, what if I only want to show the 2 most recent comments for each answer. What SQL query would I use so that I dont have to put an SQL query in a group?

...im using PHP & MYSQL for now
MYSQL comments for each post
===

How do sites like stackoverflow.com use a query to get all answers from the answers table and get all the comments associated with the answer. Also, what if I only want to show the 2 most recent comments for each answer. What SQL query would I use so that I dont have to put an SQL query in a group?

...im using PHP & MYSQL for now