Techbriefers
-
Posts
1 -
Joined
-
Last visited
Techbriefers's Achievements
Newbie (1/5)
0
Reputation
-
Techbriefers joined the community -
You can select from both the table then refine the result by loop. Select using join. SELECT m.columns..., r.columns... FROM `messages` AS m LEFT JOIN `replies` AS r ON m.message_ID = r.message_ID ORDER BY m.message_ID ASC, r.reply_ID DESC LIMIT 0,200