Try it this way:

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

-Mike