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.