{"id":19994,"date":"2023-05-25T05:22:00","date_gmt":"2023-05-25T03:22:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=19994"},"modified":"2023-07-28T17:03:30","modified_gmt":"2023-07-28T15:03:30","slug":"operateur-join-en-t-sql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/","title":{"rendered":"Jointure SQL Server avec l&rsquo;op\u00e9rateur JOIN"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-center\"><strong><em>Exemple de requ\u00eates avec l&rsquo;op\u00e9rateur JOIN \u00e9crites en langage T-SQL pour joindre les donn\u00e9es de plusieurs tables.<\/em><\/strong><\/h4>\n\n\n\n<p>En T-SQL, c&rsquo;est \u00e0 dire le langage de programmation SQL de Microsoft, une jointure SQL Server entre deux ou plusieurs tables se fait avec l&rsquo;op\u00e9rateur JOIN. Cette liaison se fait en fonction de conditions sp\u00e9cifi\u00e9es dans la clause WHERE. Il existe plusieurs variantes de l&rsquo;op\u00e9rateur JOIN, chacune avec ses propres caract\u00e9ristiques et utilisations.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#1-creer-les-tables-dexemple-des-clients-et-des-commandes\" >1. Cr\u00e9er les tables d&rsquo;exemple des clients et des commandes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#2-jointure-sql-server-de-type-inner-join\" >2. Jointure SQL Server de type INNER JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#3-operateur-t-sql-left-join\" >3. Op\u00e9rateur T-SQL LEFT JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#4-operateur-sql-server-right-join\" >4. Op\u00e9rateur SQL Server RIGHT JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#5-jointure-cross-join-sql-server\" >5. Jointure CROSS JOIN SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#6-operateur-t-sql-full-outer-join\" >6. Op\u00e9rateur T-SQL FULL OUTER JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#7-jointure-sql-server-avec-self-join-ou-auto-jointure\" >7. Jointure SQL Server avec SELF JOIN ou Auto-Jointure<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-les-tables-d-exemple-des-clients-et-des-commandes\"><span class=\"ez-toc-section\" id=\"1-creer-les-tables-dexemple-des-clients-et-des-commandes\"><\/span>1. Cr\u00e9er les tables d&rsquo;exemple des clients et des commandes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voici comment cr\u00e9er deux tables d&rsquo;exemple utilis\u00e9es dans les requ\u00eates JOIN suivantes.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1.1 Cr\u00e9er la table des Clients<\/h3>\n\n\n\n<p>Ex\u00e9cuter ce code dans SSMS par exemple pour cr\u00e9er la table des clients et y ins\u00e9rer des lignes.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9er la table des clients\nCREATE TABLE clients (\n    id INT PRIMARY KEY,\n    nom VARCHAR(255),\n    ville VARCHAR(255)\n);\n\n-- Ins\u00e9rer des lignes dans la table des clients\nINSERT INTO clients\n(id, nom, ville)\nVALUES\n(1, 'Dupont', 'Paris'),\n(2, 'Durand', 'Lyon'),\n(3, 'Martin', 'Marseille');\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">1.2 Cr\u00e9er la table des Commandes<\/h3>\n\n\n\n<p>Ensuite, cr\u00e9er la table des commandes avec le code T-SQL ci-dessous.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Cr\u00e9er la table des commandes\nCREATE TABLE commandes (\n    id INT PRIMARY KEY,\n    id_client INT,\n    montant DECIMAL(10, 2),\n    date_commande DATE\n);\n\n-- Ins\u00e9rer des lignes dans la table des commandes\nINSERT INTO commandes\n(id, id_client, montant, date_commande)\nVALUES\n(1, 1, 100.00, '2022-01-01'),\n(2, 2, 50.00, '2022-01-02'),\n(3, 1, 200.00, '2022-01-03'),\n(4, 3, 75.00, '2022-01-04');\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-jointure-sql-server-de-type-inner-join\"><span class=\"ez-toc-section\" id=\"2-jointure-sql-server-de-type-inner-join\"><\/span>2. Jointure SQL Server de type INNER JOIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur <em>INNER JOIN<\/em> permet de lier les lignes de deux tables en ne retournant que les lignes qui ont une correspondance dans les deux tables. On utilise souvent une condition de jointure dans la clause ON pour sp\u00e9cifier comment les lignes sont li\u00e9es.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM clients c\n   INNER JOIN commandes co\n      ON c.id = co.id_client;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de la requ\u00eate avec l&rsquo;op\u00e9rateur INNER JOIN comportera donc 4 lignes, comme ceci :<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>id<\/th><th>nom<\/th><th>ville<\/th><th>id<\/th><th>id_client<\/th><th>montant<\/th><th>date_commande<\/th><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-operateur-t-sql-left-join\"><\/span>3. Op\u00e9rateur T-SQL LEFT JOIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur <em>LEFT JOIN<\/em> permet de lier les lignes de deux tables en retournant toutes les lignes de la table de gauche, ainsi que les correspondances dans la table de droite si elles existent. Si une ligne de la table de gauche n&rsquo;a pas de correspondance dans la table de droite, une ligne NULL sera cr\u00e9\u00e9e dans le r\u00e9sultat pour cette ligne.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM clients c\n  LEFT JOIN commandes co\n  ON c.id = co.id_client;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de cette <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-jointure-left-join-sql-server\/\">requ\u00eate SQL LEFT JOIN \u00e9crite en T-SQL<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>id<\/th><th>nom<\/th><th>ville<\/th><th>id<\/th><th>id_client<\/th><th>montant<\/th><th>date_commande<\/th><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><tr><td>4<\/td><td>Dupuis<\/td><td>Bordeaux<\/td><td>NULL<\/td><td>NULL<\/td><td>NULL<\/td><td>NULL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-operateur-sql-server-right-join\"><\/span>4. Op\u00e9rateur SQL Server RIGHT JOIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur <em>RIGHT JOIN<\/em> est similaire au LEFT JOIN, mais il retourne toutes les lignes de la table de droite, ainsi que les correspondances dans la table de gauche si elles existent. Si une ligne de la table de droite n&rsquo;a pas de correspondance dans la table de gauche, une ligne NULL sera cr\u00e9\u00e9e dans le r\u00e9sultat pour cette ligne.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM clients c\n   RIGHT JOIN commandes co\n      ON c.id = co.id_client;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de cette requ\u00eate sera :<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>id<\/th><th>nom<\/th><th>ville<\/th><th>id<\/th><th>id_client<\/th><th>montant<\/th><th>date_commande<\/th><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><tr><td>NULL<\/td><td>NULL<\/td><td>NULL<\/td><td>5<\/td><td>2<\/td><td>25.00<\/td><td>2022-01-05<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"qLict5EzUM\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/les-types-de-donnees-sql-server\/\">Les types de donn\u00e9es SQL Server avec des exemples de code<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Les types de donn\u00e9es SQL Server avec des exemples de code\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/les-types-de-donnees-sql-server\/embed\/#?secret=T1v4N1sONI#?secret=qLict5EzUM\" data-secret=\"qLict5EzUM\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-jointure-cross-join-sql-server\"><\/span>5. Jointure CROSS JOIN SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur T-SQL <em>CROSS JOIN<\/em> permet de lier toutes les lignes de la table de gauche avec toutes les lignes de la table de droite, sans utiliser de condition de jointure.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM clients c\n   CROSS JOIN commandes co;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de cette requ\u00eate de type CROSS JOIN, ex\u00e9cut\u00e9e sur les tables d&rsquo;exemple sera comme ceci.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>id<\/th><th>nom<\/th><th>ville<\/th><th>id<\/th><th>id_client<\/th><th>montant<\/th><th>date_commande<\/th><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Il est important de noter que l&rsquo;op\u00e9rateur CROSS JOIN peut rapidement g\u00e9n\u00e9rer un tr\u00e8s grand nombre de lignes dans le r\u00e9sultat si les tables impliqu\u00e9es sont de grande taille. Il est donc recommand\u00e9 de ne l&rsquo;utiliser que lorsque cela est vraiment n\u00e9cessaire.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-operateur-t-sql-full-outer-join\"><\/span>6. Op\u00e9rateur T-SQL FULL OUTER JOIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur FULL OUTER JOIN permet de lier les lignes de deux tables en retournant toutes les lignes de la table de gauche, toutes les lignes de la table de droite, ainsi que les correspondances entre les deux tables si elles existent. Si une ligne d&rsquo;une table n&rsquo;a pas de correspondance dans l&rsquo;autre table, une ligne NULL sera cr\u00e9\u00e9e dans le r\u00e9sultat pour cette ligne.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT *\nFROM clients c\n   FULL OUTER JOIN commandes co\n      ON c.id = co.id_client;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de la requ\u00eate T-SQL avec FULL OUTER JOIN sera comme suit.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>id<\/th><th>nom<\/th><th>ville<\/th><th>id<\/th><th>id_client<\/th><th>montant<\/th><th>date_commande<\/th><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>1<\/td><td>1<\/td><td>100.00<\/td><td>2022-01-01<\/td><\/tr><tr><td>2<\/td><td>Durand<\/td><td>Lyon<\/td><td>2<\/td><td>2<\/td><td>50.00<\/td><td>2022-01-02<\/td><\/tr><tr><td>1<\/td><td>Dupont<\/td><td>Paris<\/td><td>3<\/td><td>1<\/td><td>200.00<\/td><td>2022-01-03<\/td><\/tr><tr><td>3<\/td><td>Martin<\/td><td>Marseille<\/td><td>4<\/td><td>3<\/td><td>75.00<\/td><td>2022-01-04<\/td><\/tr><tr><td>4<\/td><td>Dupuis<\/td><td>Bordeaux<\/td><td>NULL<\/td><td>NULL<\/td><td>NULL<\/td><td>NULL<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-jointure-sql-server-avec-self-join-ou-auto-jointure\"><\/span>7. Jointure SQL Server avec SELF JOIN ou Auto-Jointure<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>L&rsquo;op\u00e9rateur SELF JOIN permet de <a href=\"https:\/\/waytolearnx.com\/2019\/10\/mysql-self-join.html\" target=\"_blank\" rel=\"noreferrer noopener\">lier les lignes d&rsquo;une m\u00eame table<\/a> en utilisant deux alias diff\u00e9rents pour la table. On peut utiliser une condition de jointure dans la clause ON pour sp\u00e9cifier comment les lignes sont li\u00e9es. Cette requ\u00eate est aussi appel\u00e9e une auto-jointure.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT c1.nom, c2.nom\nFROM clients c1\n   JOIN clients c2\n      ON c1.ville = c2.ville\nWHERE c1.nom != c2.nom;\n<\/pre>\n\n\n\n<p>Le r\u00e9sultat de cette requ\u00eate avec l&rsquo;auto-jointure sera comme ceci.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><th>nom<\/th><th>nom<\/th><\/tr><tr><td>Dupont<\/td><td>Martin<\/td><\/tr><tr><td>Martin<\/td><td>Dupont<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>Il est important de noter que ces exemples de requ\u00eates avec l&rsquo;op\u00e9rateur SQL Server JOIN ne sont qu&rsquo;une introduction aux op\u00e9rateurs en T-SQL. Il est aussi possible de r\u00e9aliser des jointures avec Integration Services, notamment avec <a href=\"https:\/\/expert-only.com\/ssis\/jointure-ssis-composant-merge-join\/\">le composant SSIS Merge Join<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Conclusion sur les op\u00e9rateurs de jointures SQL Server<\/h3>\n\n\n\n<p>Une jointure SQL Server avec l&rsquo;op\u00e9rateur JOIN T-SQL et permet de combiner des donn\u00e9es de diff\u00e9rentes tables dans une seule requ\u00eate. Il existe plusieurs types d&rsquo;op\u00e9rateurs JOIN, chacun ayant ses propres caract\u00e9ristiques et utilisations. Voici quelques bonnes pratiques et avantages \u00e0 retenir concernant l&rsquo;utilisation des op\u00e9rateurs JOIN en T-SQL :<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Utiliser l&rsquo;op\u00e9rateur INNER JOIN pour renvoyer les lignes qui ont une correspondance dans les deux tables. Cet op\u00e9rateur est le plus utilis\u00e9 et le plus performant.<\/li>\n\n\n\n<li>Utiliser l&rsquo;op\u00e9rateur LEFT JOIN pour renvoyer toutes les lignes de la table de gauche, ainsi que toutes les lignes correspondantes de la table de droite. Cet op\u00e9rateur est utile pour inclure toutes les lignes de la table de gauche, m\u00eame si elles n&rsquo;ont pas de correspondance dans la table de droite.<\/li>\n\n\n\n<li>Utiliser l&rsquo;op\u00e9rateur RIGHT JOIN de mani\u00e8re similaire \u00e0 l&rsquo;op\u00e9rateur LEFT JOIN, mais en inversant l&rsquo;ordre des tables.<\/li>\n\n\n\n<li>Utiliser l&rsquo;op\u00e9rateur FULL OUTER JOIN pour renvoyer toutes les lignes des deux tables, qu&rsquo;elles aient ou non une correspondance. Cet op\u00e9rateur est moins performant que les autres op\u00e9rateurs JOIN et n&rsquo;est g\u00e9n\u00e9ralement pas recommand\u00e9 dans les requ\u00eates courantes.<\/li>\n\n\n\n<li>Utiliser l&rsquo;op\u00e9rateur CROSS JOIN pour g\u00e9n\u00e9rer un produit cart\u00e9sien de deux tables. Cet op\u00e9rateur peut rapidement g\u00e9n\u00e9rer un tr\u00e8s grand nombre de lignes dans le r\u00e9sultat, il est donc recommand\u00e9 de ne l&rsquo;utiliser que lorsque cela est vraiment n\u00e9cessaire.<\/li>\n<\/ul>\n\n\n\n<p>En r\u00e9sum\u00e9, les op\u00e9rateurs JOIN en T-SQL permettent de combiner les donn\u00e9es de plusieurs tables de mani\u00e8re efficace et pratique, ce qui peut \u00eatre tr\u00e8s utile dans de nombreuses situations. Il est important de choisir le bon type d&rsquo;op\u00e9rateur JOIN en fonction de vos besoins et de votre requ\u00eate, afin d&rsquo;obtenir le r\u00e9sultat souhait\u00e9 de mani\u00e8re efficace. Voici enfin un autre tutoriel plus d\u00e9taill\u00e9 sur les jointures sp\u00e9cifiques de type LEFT JOIN.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"v8YhhcmjmM\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-jointure-left-join-sql-server\/\">Exemples de jointure LEFT JOIN avec SQL Server<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Exemples de jointure LEFT JOIN avec SQL Server\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/exemples-jointure-left-join-sql-server\/embed\/#?secret=oEyqLsgO5i#?secret=v8YhhcmjmM\" data-secret=\"v8YhhcmjmM\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Exemple de requ\u00eates avec l&rsquo;op\u00e9rateur JOIN \u00e9crites en langage T-SQL pour joindre les donn\u00e9es de plusieurs tables. En T-SQL, c&rsquo;est \u00e0 dire le langage de programmation SQL de Microsoft, une jointure SQL Server entre deux ou plusieurs tables se <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\" title=\"Jointure SQL Server avec l&rsquo;op\u00e9rateur JOIN\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10312,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-19994","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Jointure SQL Server avec JOIN - Op\u00e9rateurs de Jointures T-SQL<\/title>\n<meta name=\"description\" content=\"L&#039;op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jointure SQL Server avec l&#039;op\u00e9rateur JOIN\" \/>\n<meta property=\"og:description\" content=\"L&#039;op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-25T03:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-28T15:03:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Jointure SQL Server avec l&rsquo;op\u00e9rateur JOIN\",\"datePublished\":\"2023-05-25T03:22:00+00:00\",\"dateModified\":\"2023-07-28T15:03:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\"},\"wordCount\":1268,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\",\"name\":\"Jointure SQL Server avec JOIN - Op\u00e9rateurs de Jointures T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg\",\"datePublished\":\"2023-05-25T03:22:00+00:00\",\"dateModified\":\"2023-07-28T15:03:30+00:00\",\"description\":\"L'op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jointure SQL Server avec l&#8217;op\u00e9rateur JOIN\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Jointure SQL Server avec JOIN - Op\u00e9rateurs de Jointures T-SQL","description":"L'op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/","og_locale":"fr_FR","og_type":"article","og_title":"Jointure SQL Server avec l'op\u00e9rateur JOIN","og_description":"L'op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-25T03:22:00+00:00","article_modified_time":"2023-07-28T15:03:30+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Jointure SQL Server avec l&rsquo;op\u00e9rateur JOIN","datePublished":"2023-05-25T03:22:00+00:00","dateModified":"2023-07-28T15:03:30+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/"},"wordCount":1268,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/","name":"Jointure SQL Server avec JOIN - Op\u00e9rateurs de Jointures T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg","datePublished":"2023-05-25T03:22:00+00:00","dateModified":"2023-07-28T15:03:30+00:00","description":"L'op\u00e9rateur JOIN en T-SQL permet de faire une jointure pour lier les lignes de deux ou plusieurs tables en fonction de conditions.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/blackboard-573023_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/operateur-join-en-t-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Jointure SQL Server avec l&#8217;op\u00e9rateur JOIN"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=19994"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/19994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10312"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=19994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=19994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=19994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}