TERMIUM Plus®
The Government of Canada’s terminology and linguistic data bank.
JOINTURE EXTERNE [9 records]
Record 1 - internal organization data 2002-10-11
Record 1, English
Record 1, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 1, Main entry term, English
- table operations for union
1, record 1, English, table%20operations%20for%20union
correct
Record 1, Abbreviations, English
Record 1, Synonyms, English
Record 1, Textual support, English
Record number: 1, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 1, English, - table%20operations%20for%20union
Record 1, French
Record 1, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 1, Main entry term, French
- opération de tables d’union
1, record 1, French, op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
correct, feminine noun
Record 1, Abbreviations, French
Record 1, Synonyms, French
Record 1, Textual support, French
Record number: 1, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 1, French, - op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
Record number: 1, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 1, French, - op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
Record 1, Spanish
Record 1, Textual support, Spanish
Record 2 - internal organization data 2002-10-11
Record 2, English
Record 2, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 2, Main entry term, English
- row value expression
1, record 2, English, row%20value%20expression
correct
Record 2, Abbreviations, English
Record 2, Synonyms, English
Record 2, Textual support, English
Record number: 2, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 2, English, - row%20value%20expression
Record 2, French
Record 2, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 2, Main entry term, French
- expression de valeur de rangée
1, record 2, French, expression%20de%20valeur%20de%20rang%C3%A9e
correct, feminine noun
Record 2, Abbreviations, French
Record 2, Synonyms, French
Record 2, Textual support, French
Record number: 2, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 2, French, - expression%20de%20valeur%20de%20rang%C3%A9e
Record number: 2, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 2, French, - expression%20de%20valeur%20de%20rang%C3%A9e
Record 2, Spanish
Record 2, Textual support, Spanish
Record 3 - internal organization data 2002-10-11
Record 3, English
Record 3, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 3, Main entry term, English
- union join
1, record 3, English, union%20join
correct
Record 3, Abbreviations, English
Record 3, Synonyms, English
Record 3, Textual support, English
Record number: 3, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 3, English, - union%20join
Record 3, French
Record 3, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 3, Main entry term, French
- jointure d’union
1, record 3, French, jointure%20d%26rsquo%3Bunion
correct, feminine noun
Record 3, Abbreviations, French
Record 3, Synonyms, French
Record 3, Textual support, French
Record number: 3, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 3, French, - jointure%20d%26rsquo%3Bunion
Record number: 3, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 3, French, - jointure%20d%26rsquo%3Bunion
Record 3, Spanish
Record 3, Textual support, Spanish
Record 4 - internal organization data 2002-10-11
Record 4, English
Record 4, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 4, Main entry term, English
- subquery in value expressions
1, record 4, English, subquery%20in%20value%20expressions
correct
Record 4, Abbreviations, English
Record 4, Synonyms, English
Record 4, Textual support, English
Record number: 4, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 4, English, - subquery%20in%20value%20expressions
Record 4, French
Record 4, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 4, Main entry term, French
- sous-interrogation dans des expressions de valeur
1, record 4, French, sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
correct, feminine noun
Record 4, Abbreviations, French
Record 4, Synonyms, French
Record 4, Textual support, French
Record number: 4, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 4, French, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
Record number: 4, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 4, French, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
Record 4, Spanish
Record 4, Textual support, Spanish
Record 5 - internal organization data 2002-10-11
Record 5, English
Record 5, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 5, Main entry term, English
- string operation
1, record 5, English, string%20operation
correct
Record 5, Abbreviations, English
Record 5, Synonyms, English
Record 5, Textual support, English
Record number: 5, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 5, English, - string%20operation
Record 5, French
Record 5, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 5, Main entry term, French
- opération de chaîne
1, record 5, French, op%C3%A9ration%20de%20cha%C3%AEne
correct, feminine noun
Record 5, Abbreviations, French
Record 5, Synonyms, French
Record 5, Textual support, French
Record number: 5, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 5, French, - op%C3%A9ration%20de%20cha%C3%AEne
Record number: 5, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 5, French, - op%C3%A9ration%20de%20cha%C3%AEne
Record 5, Spanish
Record 5, Textual support, Spanish
Record 6 - internal organization data 2002-10-11
Record 6, English
Record 6, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 6, Main entry term, English
- complement
1, record 6, English, complement
correct
Record 6, Abbreviations, English
Record 6, Synonyms, English
Record 6, Textual support, English
Record number: 6, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 6, English, - complement
Record 6, French
Record 6, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 6, Main entry term, French
- complément
1, record 6, French, compl%C3%A9ment
correct, masculine noun
Record 6, Abbreviations, French
Record 6, Synonyms, French
Record 6, Textual support, French
Record number: 6, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 6, French, - compl%C3%A9ment
Record number: 6, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 6, French, - compl%C3%A9ment
Record 6, Spanish
Record 6, Textual support, Spanish
Record 7 - internal organization data 2002-10-11
Record 7, English
Record 7, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 7, Main entry term, English
- outer join
1, record 7, English, outer%20join
correct
Record 7, Abbreviations, English
Record 7, Synonyms, English
Record 7, Textual support, English
Record number: 7, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 7, English, - outer%20join
Record 7, French
Record 7, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 7, Main entry term, French
- jointure externe
1, record 7, French, jointure%20externe
correct, feminine noun
Record 7, Abbreviations, French
Record 7, Synonyms, French
Record 7, Textual support, French
Record number: 7, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 7, French, - jointure%20externe
Record number: 7, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 7, French, - jointure%20externe
Record 7, Spanish
Record 7, Textual support, Spanish
Record 8 - internal organization data 2002-10-11
Record 8, English
Record 8, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 8, Main entry term, English
- intersection
1, record 8, English, intersection
correct
Record 8, Abbreviations, English
Record 8, Synonyms, English
Record 8, Textual support, English
Record number: 8, Textual support number: 1 CONT
The data manipulation enhancements in Intermediate SQL include: a CASE expression, CAST functions between data types, string operations, natural join, outer join, union join, row value expressions, and subqueries in value expressions, as well as table operations for union, intersection and complement. 1, record 8, English, - intersection
Record 8, French
Record 8, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 8, Main entry term, French
- intersection
1, record 8, French, intersection
correct, feminine noun
Record 8, Abbreviations, French
Record 8, Synonyms, French
Record 8, Textual support, French
Record number: 8, Textual support number: 1 CONT
Les améliorations de manipulation de données du SQL intermédiaire incluent les éléments suivants : expression CASE, fonctions CAST entre types de données, opérations de chaîne, jointure naturelle, jointure externe, jointure d’union, expressions de valeur de rangée, inclusion de sous-interrogations dans des expressions de valeur, et opérations de tables d’union, d’intersection et de complément. 1, record 8, French, - intersection
Record number: 8, Textual support number: 1 OBS
Termes (et définitions) tirés de « Langage de bases de données SQL Annexe A - Fonctions offertes par les normes qui incluent la norme NCTTI SQL » publiée par le Conseil du Trésor. 2, record 8, French, - intersection
Record 8, Spanish
Record 8, Textual support, Spanish
Record 9 - internal organization data 1985-11-15
Record 9, English
Record 9, Subject field(s)
- Data Banks and Databases
- Computer Programs and Programming
Record 9, Main entry term, English
- external join
1, record 9, English, external%20join
correct
Record 9, Abbreviations, English
Record 9, Synonyms, English
Record 9, Textual support, English
Record 9, French
Record 9, Domaine(s)
- Banques et bases de données
- Programmes et programmation (Informatique)
Record 9, Main entry term, French
- jointure externe
1, record 9, French, jointure%20externe
correct, feminine noun
Record 9, Abbreviations, French
Record 9, Synonyms, French
Record 9, Textual support, French
Record number: 9, Textual support number: 1 DEF
Opération générant une relation Relation 3 à partir de deux relations Relation 1 et Relation 2 par jointure de ces deux relations et ajout des tuples de Relation 1 et Relation 2 ne participant pas à la jointure avec des valeurs nulles pour les attributs de l’autre relation. 1, record 9, French, - jointure%20externe
Record 9, Spanish
Record 9, Textual support, Spanish
Copyright notice for the TERMIUM Plus® data bank
© Public Services and Procurement Canada, 2025
TERMIUM Plus®, the Government of Canada's terminology and linguistic data bank
A product of the Translation Bureau
Features
Language Portal of Canada
Access a collection of Canadian resources on all aspects of English and French, including quizzes.
Writing tools
The Language Portal’s writing tools have a new look! Easy to consult, they give you access to a wealth of information that will help you write better in English and French.
Glossaries and vocabularies
Access Translation Bureau glossaries and vocabularies.
- Date Modified: