Some problem creating a little php code!

[npsari]

hello there

 

in my phpbb forums, i am using this code to display the image of the person who posted a topic (I am joining 2 tables)

 

SELECT t.topic_id, t.topic_title, t.topic_views, t.topic_replies, u.user_avatar
FROM phpbb_topics t
LEFT JOIN phpbb_users u
ON u.user_id = t.topic_poster
ORDER BY t.topic_last_post_id DESC LIMIT 10

 

So now, the above code gets the image of the user where user_id = topic_poster

 

but i also want to show the image of the person who replied too

 

if the person who last replied is stored as letest_reply_poster in a table called replies

 

how can i write the above code please