O'Reilly logo
  • Dustin Waybright thinks this is interesting:

Often, when joining tables, you join them based on a foreign key–unique key relationship.


Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012


A primary key is unique on the primary table and the foreign key likely is not.