Multiple Join between One or More Table using MySQL

Bhushan Singh

10y1.3kCode

This code snippet for multiple join between one or more table using mysql.

SELECT Table4.company, table1.id, table1.value
FROM Table1
    INNER JOIN Table1
        ON Table2.table1_id = Table1.id
    INNER JOIN Table3
        ON Table3.table2_id = Table2.id
    INNER JOIN Table4
        ON Table4.table3_id = Table3.id