JOIN maybe sql

crazy_fool

Ok so just say i have 3 tables that i need to join
i have them joined but i need another join
$sql = "SELECT * FROM topics
JOIN text
ON text.msg_id = topics.mt_msg_id
JOIN members
ON topics.mt_from_id = members.id";
ok simple right, well i need another join to join members.login and topics.mt_to_id
how would i go about that?
Thanks

crazy_fool

Is there any way for me to do this??

Piranha

Yes. Your first action should be to wait more than an hour before demanding an answer.

crazy_fool

Oh right, sorry, its just i do need an answer, but i did wait an hour before i did actually ask again

Lars_Berg

SELECT m1.login as fromName, m2.login as toName,<otherColumnsOfInterest> 
 FROM topics
JOIN text
ON text.msg_id = topics.mt_msg_id
JOIN members m1
ON topics.mt_from_id = m1.id
JOIN members m2
ON topics.mt_to_id = m2.id