French | English |
chemin de jointure | join path (A series of joins indicating how two tables are related) |
colonne de jointure | join column (A column referenced in a join condition) |
condition de jointure | join condition (A comparison clause that specifies how tables are related by their join columns) |
filtre de jointure | join filter (A filter used in merge replication that extends the row filter of one table to a related table) |
jointure en étoile | star join (A join between a fact table (typically a large fact table) and at least two dimension tables) |
jointure externe | outer join (A join that includes all the rows from the joined tables that meet the search conditions, even rows from one table for which there is no matching row in the other join table) |
jointure externe droite | right outer join (An outer join in which all the records from the right side of the RIGHT JOIN operation in the query's SQL statement are added to the query's results, even if there are no matching values in the joined field from the table on the left) |
jointure externe entière | full outer join (A type of outer join in which all rows in all joined tables are included, whether they are matched or not. For example, a full outer join between titles and publishers shows all titles and all publishers, even those that have no match) |
jointure externe gauche | left outer join (A type of outer join in which all rows from the left-most table in the JOIN clause are included. When rows in the left table are not matched by rows in the right table, all result set columns that come from the right table are assigned a value of NULL) |
jointure interne | inner join (An operation that retrieves rows from multiple source tables by comparing the values from columns shared between the source tables. An inner join excludes rows from a source table that have no matching rows in the other source tables) |
jointure réflexive | self-join (A join in which records from a table are combined with other records from the same table when there are matching values in the joined fields. A self-join can be an inner join or an outer join. In database diagrams, a self-join is called a reflexive relationship) |
ligne de jointure | join line (A line that connects fields between two tables and shows how the data is related. The type of join indicates which records are selected for the query's result set) |
opérateur de jointure | join operator (A comparison operator in a join condition that determines how the two sides of the condition are evaluated and which rows are returned) |
style de jointure | join style (A style that specifies how the ends of connected lines are joined) |
table de jointure | junction table (A table that establishes a relationship between other tables) |
thêta-jointure | theta join (A join based on a comparison of scalar values) |