Monday, June 1, 2009

Equijoin

Equijoin

CATEGORY: Relationships
CLASS: Operator

The equijoin relationship is where the to matching fields have to have equal data in order for the relationship to be valid. This means the only operator used in the relationship is the equal sign (=).

Here is a listing of non-equijoin relationships ...

≠ ( not equal )
> ( greater than )
< ( less than )
≥ ( greater than or equal to )
≤ ( less than or equal to )
x ( means all records in both table occurrence compare, no matter the data in either )

Here are some links to other posts that might be of interest in regards to this topic...
Unequal Comparison Relationship

ADVERTISEMENT ==================
Help support this blog by considering a donating to its ongoing growth. For more details, please visit http://www.dwaynewright.com/donate.html