title: SQL join tables without common key
body: <p>New to SQL.  I'm working with AdventureWorks 2012 trying to familiarize myself with SQL server.  Having trouble joining tables that don't share a common key.  Can this be done?  </p>
  
  <p>If you're familiar with the AdventureWorks DB I'm trying to return the Name (FirstName, MIddleName, LastName), AddressType, and Address (Combination of AddressLine1, Address Line2, City, State, PostalCode) but that draws from 3 different tables and they don't share any key that can link them together.</p>