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, TA
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 TABLE