This screencast is part 11 (11/27) of the Learn Views with NodeOne screencast series, going over relationships.
-How to add relationships in Views.
-How to use relationships to get node data in a list of files.
-How to use relationships to get data from referenced nodes in a node list.
-Some words about the Relation module.