Relational operator | Matches these records |
= | Values in match fields are equal |
≠ | Values in match fields are unequal |
< | Values in the left match field are less than values in the right match field |
≤ | Values in the left match field are less than or equal to values in the right match field |
> | Values in the left match field are greater than values in the right match field |
≥ | Values in the left match field are greater than or equal to values in the right match field |
x | All records in the left table are matched to all records in the right table, regardless of the values in the match fields (sometimes called a Cartesian product relationship) |
Table | Field name | Comment |
TableC | DateFieldC | Match field to DateFieldD; records in TableD are related to records in TableC that have a later DateFieldC value |
TableD | DateFieldD | Match field to DateFieldC; records in TableC are related to records in TableD that have an earlier DateFieldD value |