Thundarfoot Posted February 1, 2008 Share Posted February 1, 2008 I am a noob, here is my sign: ??? I have a 3 column table as such ..id...armsid...mobid ..1.....40........25 ..2.....100......4 armsid = id for arms table. mobid = id for mob table. I had previously been joining 2 tables together, and was using the below code with a 2 colum join. SELECT * FROM lt_r5_armor LEFT OUTER JOIN mobs ON (lt_r5_armor.mobid = mobs.id) how do I do about making 2 joins at the same time? hope I am making sense. and thank you for your time and help. Quote Link to comment https://forums.phpfreaks.com/topic/88866-solved-2-joins-at-once/ Share on other sites More sharing options...
Barand Posted February 1, 2008 Share Posted February 1, 2008 SELECT * FROM lt_r5_armor lt INNER JOIN mobs m ON lt.mobid = m.id INNER JOIN arms a ON lt.armsid = a.id Quote Link to comment https://forums.phpfreaks.com/topic/88866-solved-2-joins-at-once/#findComment-455229 Share on other sites More sharing options...
Thundarfoot Posted February 1, 2008 Author Share Posted February 1, 2008 mucho gracias thank you very much~ Quote Link to comment https://forums.phpfreaks.com/topic/88866-solved-2-joins-at-once/#findComment-455589 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.