joining three tables is not much different than joining 2 tables
SELECT * from table1
<join type> table2 ON <relation columns from 2 tables>
<join type>table3 ON <relation columns from 2 tables>
the blog i linked to describes the different join types and how the effect the results. the join type yo are using in the query is causing the member ID to not return, try experimenting with the different join types.