can you give the table structure for all 3 tables, it seams like you aren't doing the join on the correct column.
The join should be done on the linking columns in the featured table
this tutorial should help with nested recordsets:
http://www.webassist.com/tutorials/Display-nested-recordsets