Get uid of Content profile node

Hello,

Sorry if I've missed something obvious. How do I get the uid of a content profile node (not the author but the Content profile association) I can't see how Content profile stores the relationship (uid - profile nid) in the DB.

I have set up a profile for my users - users can then chose a taxonomy term. What I want to do is create a view that lists all content posted by all users of a particular term. - I was planning on doing this by having a php function that returned all the uid's associated to a term and passing that as an argument to the view - if there is a better way I'm open to suggestions. I'm using Drupal 6.

Thanks in advance

John