PHP DB - mysql INNER JOIN

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

mysql INNER JOIN

ioannes

2005-05-28, 8:55 pm

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

Sponsored Links