The syntax is not quite right. The correct syntax should be as follows.
join member m on
join district d on
join city c on
t.mem_id=158If you have rows in one table for which there are no corresponding rows in all the other tables, such rows will not be returned via this query. You will need to use one of the outer joins if you do want to return such rows.