TERMIUM Plus®
The Government of Canada’s terminology and linguistic data bank.
JOINTURE UNION [9 records]
Record 1 - external organization data 2010-12-23
Record 1, English
Record 1, Subject field(s)
- Compartment - ISO/IEC JTC 1 Information Technology Vocabulary
Universal entry(ies) Record 1
Record 1, Main entry term, English
- relational algebra
1, record 1, English, relational%20algebra
correct, standardized
Record 1, Abbreviations, English
Record 1, Synonyms, English
Record 1, Textual support, English
Record number: 1, Textual support number: 1 DEF
algebra for expressing and manipulating relations 1, record 1, English, - relational%20algebra
Record number: 1, Textual support number: 1 OBS
Common operations in a relational algebra are projection, selection, join, Cartesian product, disjunction, conjunction, and difference. 1, record 1, English, - relational%20algebra
Record number: 1, Textual support number: 2 OBS
relational algebra: term and definition standardized by ISO/IEC [ISO/IEC 2382-17:1999]. 2, record 1, English, - relational%20algebra
Record 1, French
Record 1, Domaine(s)
- Tiroir - ISO/CEI JTC 1 Vocabulaire des technologies de l'information
Entrée(s) universelle(s) Record 1
Record 1, Main entry term, French
- algèbre relationnelle
1, record 1, French, alg%C3%A8bre%20relationnelle
correct, feminine noun, standardized
Record 1, Abbreviations, French
Record 1, Synonyms, French
Record 1, Textual support, French
Record number: 1, Textual support number: 1 DEF
algèbre permettant d’exprimer et de manipuler des relations 1, record 1, French, - alg%C3%A8bre%20relationnelle
Record number: 1, Textual support number: 1 OBS
En algèbre relationnelle, les opérations courantes sont la projection, la sélection, la jointure, le produit cartésien, l'union, l'intersection et la différence. 1, record 1, French, - alg%C3%A8bre%20relationnelle
Record number: 1, Textual support number: 2 OBS
algèbre relationnelle : terme et définition normalisés par l’ISO/CEI [ISO/IEC 2382-17:1999]. 2, record 1, French, - alg%C3%A8bre%20relationnelle
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
- table operations for union
1, record 2, English, table%20operations%20for%20union
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, - table%20operations%20for%20union
Record 2, French
Record 2, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 2, Main entry term, French
- opération de tables d’union
1, record 2, French, op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
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, - op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
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, - op%C3%A9ration%20de%20tables%20d%26rsquo%3Bunion
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
- row value expression
1, record 3, English, row%20value%20expression
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, - row%20value%20expression
Record 3, French
Record 3, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 3, Main entry term, French
- expression de valeur de rangée
1, record 3, French, expression%20de%20valeur%20de%20rang%C3%A9e
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, - expression%20de%20valeur%20de%20rang%C3%A9e
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, - expression%20de%20valeur%20de%20rang%C3%A9e
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
- union join
1, record 4, English, union%20join
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, - union%20join
Record 4, French
Record 4, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 4, Main entry term, French
- jointure d'union
1, record 4, French, jointure%20d%27union
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, - jointure%20d%27union
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, - jointure%20d%27union
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
- subquery in value expressions
1, record 5, English, subquery%20in%20value%20expressions
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, - subquery%20in%20value%20expressions
Record 5, French
Record 5, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 5, Main entry term, French
- sous-interrogation dans des expressions de valeur
1, record 5, French, sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
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, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
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, - sous%2Dinterrogation%20dans%20des%20expressions%20de%20valeur
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
- string operation
1, record 6, English, string%20operation
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, - string%20operation
Record 6, French
Record 6, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 6, Main entry term, French
- opération de chaîne
1, record 6, French, op%C3%A9ration%20de%20cha%C3%AEne
correct, feminine 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, - op%C3%A9ration%20de%20cha%C3%AEne
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, - op%C3%A9ration%20de%20cha%C3%AEne
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
- complement
1, record 7, English, complement
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, - complement
Record 7, French
Record 7, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 7, Main entry term, French
- complément
1, record 7, French, compl%C3%A9ment
correct, masculine 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, - compl%C3%A9ment
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, - compl%C3%A9ment
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
- outer join
1, record 8, English, outer%20join
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, - outer%20join
Record 8, French
Record 8, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 8, Main entry term, French
- jointure externe
1, record 8, French, jointure%20externe
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, - jointure%20externe
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, - jointure%20externe
Record 8, Spanish
Record 8, Textual support, Spanish
Record 9 - internal organization data 2002-10-11
Record 9, English
Record 9, Subject field(s)
- Programming Languages
- Computer Display Technology
- Computer Programs and Programming
Record 9, Main entry term, English
- intersection
1, record 9, English, intersection
correct
Record 9, Abbreviations, English
Record 9, Synonyms, English
Record 9, Textual support, English
Record number: 9, 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 9, English, - intersection
Record 9, French
Record 9, Domaine(s)
- Langages de programmation
- Techniques d'affichage (Ordinateurs)
- Programmes et programmation (Informatique)
Record 9, Main entry term, French
- intersection
1, record 9, French, intersection
correct, feminine noun
Record 9, Abbreviations, French
Record 9, Synonyms, French
Record 9, Textual support, French
Record number: 9, 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 9, French, - intersection
Record number: 9, 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 9, French, - intersection
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: