A self join can be of any type, as long as the joined tables are the same.
既然联接的是同一个表,那么自联接可以是任一种类型。
A self join is rather unique in that it involves a relationship with only one table.
自联接是相当独特的,它只涉及到仅仅一个表的关系。
A new feature of the query optimizer supports a new type of index scan, called an index self-join path.
查询优化器的一项新特性支持一种新的索引扫描,即索引自连接路径。
For example, you can use a self-join to find pairs of authors living in the same city.
例如,可使用自联接查找生活在同一城市的作者对。
Steps for allowing the Query and View Designer to create a self-join.
让查询和视图设计器创建自联接的步骤。
As with any join, a self-join requires at least two tables.
与任何联接一样,自联接至少需要两个表。
Creating a self-join often requires multiple join conditions.
创建自联接通常需要多个联接条件。
Creating a self-join often requires multiple join conditions.
创建自联接通常需要多个联接条件。
应用推荐