I have a table that stores comment info for a message board. The table has comment_body, id, and commenter_id in it. there is another table with all the members that can post comments (member_id, member_name). I want to be able to sort a question by the commenter name (not id). I can't figure out how to sort the table alphabetically by info that is stored in another table.
if it is a complicated solution, I will raise the points.