Drupal Bits: Views 2 Relationships
In around 8 minutes, I understood the concept of Views 2 Relationships by watching this video. Relationships helps you connect relate (duh) nodes to other nodes. In short, it is probably most helpful to think about this as a SQL join.
Check out this video from drewish.com for the screencast:
