kenno69 Posted January 13, 2008 Share Posted January 13, 2008 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 Link to comment https://forums.phpfreaks.com/topic/85860-join/ Share on other sites More sharing options...
pocobueno1388 Posted January 13, 2008 Share Posted January 13, 2008 SELECT * FROM topics JOIN text ON text.msg_id = topics.mt_msg_id JOIN members ON topics.mt_from_id = members.id JOIN topics ON topics.mt_to_id = members.login Link to comment https://forums.phpfreaks.com/topic/85860-join/#findComment-438365 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.