The JMP Query Builder from the Tables menu is how to join more than 2 tables in one step, so you are using the right platform. Why it doesn't work could be due to several factors but usually it would be because you are doing an inner join on columns with no matching values. Try changing the join to a full outer join, that should definitely return a result.