Excerpt. © Reprinted by permission. All rights reserved.
Excerpt:
Joins "Using JOINs in your statements gives you better control of the results you will get from a statement. Typically, JOINs are performed on tables that have a Primary Key - Foreign Key relationship. This may not always be the case, though. The only real requirement for JOINs is that each column participating in the JOIN be of like data types and have like values within each table."
