How to merge multiple tables into one?

Question

MySQL

There are several tables of the form:
id -name, id - suname, id -job
How can I merge them into one table of the form:
id - name - suname - job

Answer 1

If the id is the same (That is, we have one "person" with an id, for example, 5 whose first name is recorded under id 5 in table t1, whose last name is under id 5 in table t2, and whose work is under id 5 in table t3) then:

SELECT 
t1.id, t1.name, t2.suname, t3.job 
FROM t1
INNER JOIN t2 ON t1.id = t2.id
INNER JOIN t3 ON t1.id = t3.id