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. 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 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~ 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
Archived
This topic is now archived and is closed to further replies.