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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.