Definitions for "Join condition"
Keywords:  equijoin, clause, pub, anywhere, tables
a search condition, with some restrictions
A comparison clause that specifies how tables are related via their join fields. The most common join condition is equivalence (an equijoin) in which the values of the join fields must be the same. For example, you can join the titles and publishers tables by finding values that match in their respective pub_id columns. However, any comparison operator can be part of a join condition.
The specification within the WHERE clause of a query join that specifies the manner in which the rows in the different tables are paired.
Keywords:  boolean, expressions, see
a Boolean expression (see Expressions )