| INNER JOIN de 4 Tablas | |||
|---|---|---|---|
| Tabla 1 | Tabla 2 | Tabla 3 | Tabla 4 |
| id | product_id | code | price |
| 1 | ABC123 | AAA | 10.00 |
| 2 | ABC123 | BBB | 12.00 |
| 2 | XYZ987 | AAA | 15.00 |
SELECT *
FROM Table_1 T1
INNER JOIN Table_2 T2
ON T1.id = T2.product_id
INNER JOIN Table_3 T3
ON T2.product_id = T3.product_id
INNER JOIN Table_4 T4
ON T3.code = T4.code
Inner Join Mysql Ejemplos 4 Tablas