mysql INNER JOIN

["ioannes" <ioannes@xxxxxxxxxxxxxx>]

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 

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php