...or, in other words, how to create a simple join as I would do in SQL?

Suppose I want the following information:

Just as an example:

* a person's full name
* a person's hobbies.

His full name is in a (content profile) node type 'name\_and\_address' and his hobbies are in 'hobbies'.

In SQL, I would link them together by node.uid.
I've seen a bit about using relationships, but that goes with user-node-refs.
I just want the same user from one content-type and the other.

Now how could I get his name and his hobbies in 1 view?