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.