mysql INNER JOIN

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux