MariaDB [SANDBOX]> SELECT * from TEST_RDT_2 JOIN TEST_RDT_3 ON TEST_RDT_2.ID = TEST_RDT_3.ID LEFT OUTER JOIN TEST_RDT_1 ON TEST_RDT_1.ID = TEST_RDT_2.ID;

ERROR 1054 (42S22): Unknown column 't0.ID' in 'on clause'

MariaDB [SANDBOX]> SELECT * from TEST_RDT_2 LEFT OUTER JOIN TEST_RDT_1 ON TEST_RDT_1.ID = TEST_RDT_2.ID JOIN TEST_RDT_3 ON TEST_RDT_2.ID = TEST_RDT_3.ID ;

+----+-----------+------+-----------+----+---------+

| ID | LASTNAME  | ID   | FIRSTNAME | ID | SURNAME |

+----+-----------+------+-----------+----+---------+

|  1 | DEMONGEOT |    1 | RICHARD   |  1 | CON     |

|  2 | VAROQUI   |    2 | STEPHANE  |  2 | MOYEN   |

+----+-----------+------+-----------+----+---------+

2 rows in set (0.008 sec)