The join conditions combine with the WHERE and HAVING search conditions to control the rows that are selected from the base tables referenced in the FROM clause.

• 联接条件与WHERE和HAVING搜索条件相结合,用于控制从FROM子句所引用的基表中选定的行。