Thanks,
but was is wrong with the follow query:

SELECT a.*, e.title, b.department, d.function, c.apostrophe
FROM table1 a;
INNER JOIN table b;
INNER JOIN table c;
ON a.b_id = b.id ;
ON a.c_id = c.id ;
WHERE a.number = "XXX"