when i add a content-profile relationship to a user views, i didn't seem to be able to pull anything out of the actual content profile, and in the query i saw:
LEFT JOIN node node_users ON users.uid = node_users.uid AND node_users.type = ''

took ages to actually check the config screen for the relationship...i somehow missed it the first time.

so, just a thought that maybe a default_value could be set?

thanks