I currently have a content view that displays a list of nodes for a blog. I would like to display the node authors real name (John Smith) at the top, but currently I am only able to display their username (john_smith) by creating a relationship to Content: Author and then adding User: Name.
How can I grab some fields from the node authors user profile?
The fields I need are $field_first_name, $field_last_name, $field_position.
FYI: I realize that there are modules that might be able to fix this problem such as Real Name, but I am hoping to do this without it.