[RESOLVED] Join Tables

[BlueGemini]

Can I Join more than 2 tables when using the JOIN? 😕

[bogu]

Yeap.

[BlueGemini]

bogu wrote:

Yeap.

How can I do it? I mean could you give me an example?

[bogu]

Something like this ....

SELECT
    *
FROM `table` t1
LEFT JOIN `table2` t2 ON t2.`field` = t1.`field`
LEFT JOIN `table3` t3 ON t3.`field` = t2.`field`
......
LEFT JOIN `tablen` tn ON tn.`field` = tm.`field`

[BlueGemini]

bogu wrote:

Something like this ....

SELECT
    *
FROM `table` t1
LEFT JOIN `table2` t2 ON t2.`field` = t1.`field`
LEFT JOIN `table3` t3 ON t3.`field` = t2.`field`
......
LEFT JOIN `tablen` tn ON tn.`field` = tm.`field`

Should I only use the LEFT JOIN?

Anyway, I'll just check it out.

Thanks