Difference between revisions of "Non-Equality Joins"
Jump to navigation
Jump to search
(Created page with "'''With an equality join, the data value of a record stored in the common column for the first''' '''table must match the data value in the second table. However, in many case...") |
(No difference)
|
Revision as of 23:06, 23 October 2017
With an equality join, the data value of a record stored in the common column for the first table must match the data value in the second table. However, in many cases, there’s no exact match. A non-equality join is used when the related columns can’t be joined with an equal sign—meaning there are no equivalent rows in the tables to be joined.