mysql INNER JOIN
| From: | ioannes | Date: | Sat, 28 May 2005 20:03:03 +0000 |
| Subject: | mysql INNER JOIN | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-39561@lists.php.net to get a copy of this message | ||
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