This can be done the Views module using views relationships. Create relationships to the other nodes and then leverage these when selecting which fields to display.
Carl Wiedemann Website design and development consulting carl.wiedemann@gmail.com | skype: c4rlww