Vote count:
0
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?
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.
asked 1 min ago
Aucun commentaire:
Enregistrer un commentaire