
Sometimes working on Drupal Views is very intimidating as this a very complex module
serving a variety of needs. No wonder it is one of top Drupal modules. Once I had a particularly
difficult time trying to figure out how to get a relationship right in Views by trying to get the user
name from the users table using a userid from a field in my custom table. However I managed to
figure out the soution by reading the query generated by Views. Read on to know how to add a relationship
between a custom table and Users table in Views below