[SOLVED] 2 joins at once?

[Thundarfoot]

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.

[Barand]

SELECT *

FROM lt_r5_armor lt

INNER JOIN mobs m ON lt.mobid = m.id

INNER JOIN arms a ON lt.armsid = a.id

[Thundarfoot]

mucho gracias

thank you very much~