Re: mysql INNER JOIN

have a look at http://www.webmasterworld.com/forum88/3653.htm hope this helps! Mike ioannes wrote:

I usually use INNER JOIN to link tables together in a straight line, like a branch. Can I use it to link tables like twigs stemming off the branch. If so, do I use: SELECT TABLE1.FIELD, TABLE2.FIELD, TABLE3.FIELD FROM ( TABLE1 INNER JOIN TABLE2 ON TABLE1.FIELD =TABLE2.FIELD ) INNER JOIN TABLE3 ON TABLE1.FIELD=TABLE3.FIELD or if the join has to be in the middle: SELECT TABLE_1.FIELD, TABLE_2.FIELD, TABLE_3.FIELD, TABLE_4.FIELD FROM TABLE_1 INNER JOIN ( TABLE_2 INNER JOIN TABLE_3 ON TABLE_2.FIELD =TABLE_3.FIELD ) ON TABLE_1.FIELD=TABLE_2.FIELD INNER JOIN TABLE_4 ON TABLE1.FIELD=TABLE3.FIELD John