Hi!

I have three tables:

messages (ID, subject, timestamp);
messages_users (ID, mailid, userid);
messages_replies(ID,mailid,userid, message, timestamp);

What I want to do is display a list of their messages and the user's who are involved in the conversation.

So for example I could do this in two queryies:

SELECT * FROM messages

then during the loop I could get the users

SELECT * FROM messages_users WHERE mailid = ?

loop through users and output

Is it possible to create one query for just this?