Range joins

When you create joins between tables in the relationship editor, you can specify ranges as values for the matched columns by using comparison operators, such as less than (<) or greater than (>).

A relationship that uses this type of join is often created to return a range of dates or serial numbers.

For more information, see Join operators.