[Solved] SELECT * FROM table1, table2, table3 [duplicate]


You should use joins.

Your query will look like :

SELECT t3.name
FROM table3 t3
LEFT JOIN table2 t2 ON t3.id = t2.id2
LEFT JOIN table1 t1 ON t2.id2 = t1.id
WHERE t1.id = <your_number>

1

solved SELECT * FROM table1, table2, table3 [duplicate]