Join with 3 tables

magentoplay

Dears,
the acutal example of:
http://editor.datatables.net/examples/simple/join.html

show only how to do with 2 tables.
Please can anyone give the example with 3 tables? I use PHP and Mysql
Thanks so much.

crush123

http://editor.datatables.net/examples/index

In advanced initialisation, there are more examples

Join tables - self referencing join - http://editor.datatables.net/examples/advanced/joinSelf.html
Join tables - link table
http://editor.datatables.net/examples/advanced/joinLinkTable.html
Join tables - one-to-many join
http://editor.datatables.net/examples/advanced/joinArray.html

allan

The principle is exactly the same as the two table join - you would just specify an additional leftJoin() as per the documentation linked to by @crush123.

Allan