Relationcondition
Relationcondition is a term used in data management and logic to denote a constraint or predicate that ties together two or more relations by asserting a relation between their attributes. It is a general concept for expressing how data in distinct relations should correspond to each other, and it underpins join operations, query predicates, and certain data-integrity rules.
It can take several forms. A simple equality predicate between shared attributes constitutes an equi-join condition,
As semantics, a relationcondition is evaluated against a particular database state. A pair of tuples from the
Relationcondition is closely related to terminology in databases and logic, including join predicates, theta joins, equijoins,