[Solved] How to get data 3 tables?

by


You need to do a join on the tables in order to get the columns of all of them.

Warning: using * to get all columns is bad practice. You should qualify (name) all the columns you need.

Here is an example:

SELECT * 
FROM table1 t1
INNER JOIN table2 t2
  ON t1.key2 = t2.key2
INNER JOIN table3 t3
  ON t1.key3 = t3.key3

solved How to get data 3 tables?