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...") |
|||
| Line 4: | Line 4: | ||
'''an equal sign—meaning there are no equivalent rows in the tables to be joined.''' | '''an equal sign—meaning there are no equivalent rows in the tables to be joined.''' | ||
'''A non-equality join enables you to store a range’s minimum value in one column of a''' | |||
'''record and the maximum value in another column. So instead of finding a column-to column''' | |||
'''match, you can use a non-equality join to determine whether the item being shipped''' | |||
'''falls between minimum and maximum ranges in the columns.''' | |||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Revision as of 23:10, 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.
A non-equality join enables you to store a range’s minimum value in one column of a record and the maximum value in another column. So instead of finding a column-to column match, you can use a non-equality join to determine whether the item being shipped falls between minimum and maximum ranges in the columns.