Get field from another content type in Views
I cannot give you a very detailed answer, mainly because it has been too long since I built new things with Drupal 6, but also because I don't know which Views version you are using.

But anyway, the key to your answer is "relationships". Views allows you to define a relationship from one item to another (for instance: node -&gt; author (user)) and then query properties of the related item (node -&gt; author[name]). You can even chain relationships, so you can query a property of a related item of a related item. This seems to be what you need: node -&gt; author -&gt; node[field].

For more info I recommend that you find some video's or tutorials about views relationships, like these ones:


http://gotdrupal.com/videos/drupal-views-relationships
http://drupaleasy.com/blogs/ultimike/2009/07/using-views-relationships-arguments-attachments