{"id":57687,"date":"2021-05-04T09:07:52","date_gmt":"2021-05-04T08:07:52","guid":{"rendered":"https:\/\/datascientest.com\/?p=57687"},"modified":"2023-11-09T14:07:23","modified_gmt":"2023-11-09T14:07:23","slug":"tout-comprendre-des-jointures-sql","status":"publish","type":"post","link":"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql","title":{"rendered":"Jointures SQL : tout comprendre sur l&rsquo;association de tables"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"57687\" class=\"elementor elementor-57687\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c9bfd1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c9bfd1\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-09c3d1f\" data-id=\"09c3d1f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-339cfd9 elementor-widget elementor-widget-heading\" data-id=\"339cfd9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Si vous \u00eates fid\u00e8le \u00e0 notre blog, vous avez d\u00e9j\u00e0 entendu parler de SQL ou \u201cStructured Query Language\u201d: langage de programmation pour g\u00e9rer des bases de donn\u00e9es et vous \u00eates au courant de l\u2019importance des jointures SQL.\u00a0<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4bf485f elementor-widget elementor-widget-text-editor\" data-id=\"4bf485f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"color: #000000;\">Si vous avez manqu\u00e9 l\u2019article pour\u00a0<\/span><a href=\"https:\/\/datascientest.com\/sql-tout-savoir\" target=\"_blank\" rel=\"noopener\">conna\u00eetre les bases du langage SQL<\/a>. On vous le redonnes ici.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0135791 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0135791\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6e8f067\" data-id=\"6e8f067\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-60ef4bf elementor-widget elementor-widget-text-editor\" data-id=\"60ef4bf\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">A premi\u00e8re vue, les jointures en SQL peuvent para\u00eetre compliqu\u00e9es ou difficiles \u00e0 appliquer. DataScientest vous propose un petit r\u00e9cap des principales jointures en SQL avec un exemple tout simple pour vous faciliter la vie\u202f!\u00a0<br \/><\/span><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Mais avant tout, une jointure, qu\u2019est-ce que c\u2019est\u202f?\u00a0\u00a0<\/span><\/span><\/p><p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Les jointures permettent de r\u00e9cup\u00e9rer des donn\u00e9es dans une base de donn\u00e9es o\u00f9 les tables ont des relations entre elles.<br \/><\/span><\/span><span style=\"font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-size: var( --e-global-typography-text-font-size );\">Elles permettent d\u2019exploiter les tables d\u2019une base de donn\u00e9es, de les lier et d\u2019obtenir des r\u00e9sultats efficaces.<\/span><\/p><p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\"> Il en existe plusieurs types, nous allons aborder les principales.\u00a0<\/span><\/span><\/p><p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">Tout au long de cet article on va s\u2019appuyer sur deux tables\u202f:\u00a0<\/span><\/span><\/p><ul><li><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\"> montre les villes o\u00f9 vit le client correspondant \u00e0 l\u2019id_client,\u00a0<\/span><\/span><\/li><li><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">la table <\/span><b>email<\/b><\/span><span style=\"font-weight: 400;\"><span style=\"color: #000000;\"> donne les coordonn\u00e9es mails des clients.<\/span> <\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9ef5102 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ef5102\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-63f07b2\" data-id=\"63f07b2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a88eead elementor-widget elementor-widget-heading\" data-id=\"a88eead\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ville<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7c82c5b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7c82c5b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-374534c\" data-id=\"374534c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6adf5c3 elementor-widget elementor-widget-image\" data-id=\"6adf5c3\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"138\" height=\"111\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/pngbase641ee84728471b5b81.png\" class=\"attachment-full size-full wp-image-57706\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f61b5ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f61b5ad\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-de3389e\" data-id=\"de3389e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d940ec1 elementor-widget elementor-widget-heading\" data-id=\"d940ec1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Email<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ddf6efe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ddf6efe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9fd2f2a\" data-id=\"9fd2f2a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-227a376 elementor-widget elementor-widget-image\" data-id=\"227a376\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"402\" height=\"109\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-3-1.png\" class=\"attachment-full size-full wp-image-57711\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-3-1.png 402w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-3-1-300x81.png 300w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ddbdca6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ddbdca6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dd38327\" data-id=\"dd38327\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-16f4298 elementor-widget elementor-widget-heading\" data-id=\"16f4298\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">1. INNER JOIN <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ea2edfc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ea2edfc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4fd928f\" data-id=\"4fd928f\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-765f5f2 elementor-widget elementor-widget-text-editor\" data-id=\"765f5f2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">La jointure interne ou INNER JOIN permet de retourner les donn\u00e9es <\/span><b>quand la condition est vraie dans les deux tables<\/b><span style=\"font-weight: 400;\">.\u00a0\u00a0<\/span><\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Comme le montre le sch\u00e9ma, ce type de jointure va permettre de concat\u00e9ner les tuples des 2 tables deux \u00e0 deux si une condition est satisfaite. Cette condition peut \u00eatre de tout type tant qu&rsquo;elle retourne <a href=\"https:\/\/fr.wikipedia.org\/wiki\/Bool%C3%A9en\">un bool\u00e9en<\/a>. Typiquement, cette condition sera l&rsquo;\u00e9galit\u00e9 d&rsquo;un attribut en commun. Il est n\u00e9cessaire de sp\u00e9cifier les attributs \u00e0 utiliser pour effectuer la jointure. On utilise le mot cl\u00e9\u202fON\u202fsuivi de l&rsquo;\u00e9galit\u00e9 souhait\u00e9e apr\u00e8s avoir renseign\u00e9 les tables dans l&rsquo;INNER JOIN.\u00a0<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e32a640 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e32a640\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ae398fd\" data-id=\"ae398fd\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-041b686 elementor-widget elementor-widget-image\" data-id=\"041b686\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"180\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/Fichier-14.png\" class=\"attachment-full size-full wp-image-65847\" alt=\"jointure sql\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Intersection de deux ensembles <\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-98ec855 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"98ec855\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-689a3f6\" data-id=\"689a3f6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1aa037a elementor-widget elementor-widget-text-editor\" data-id=\"1aa037a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">C\u2019est la requ\u00eate qui fait perdre le plus d\u2019informations puisqu\u2019elle ne s\u00e9lectionne que les lignes des deux tables o\u00f9 il y a des informations dans les deux tables.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-028dbfe elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"028dbfe\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-837b03d\" data-id=\"837b03d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0b2da38 elementor-widget elementor-widget-shortcode\" data-id=\"0b2da38\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/EmilieGreff1\/9c695365de13aad9709b1758a13d7948.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c7306f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c7306f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-20cc88a\" data-id=\"20cc88a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4f97324 elementor-widget elementor-widget-image\" data-id=\"4f97324\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"414\" height=\"97\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/pngbase64296d64bfc2d1932f.png\" class=\"attachment-full size-full wp-image-57724\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/pngbase64296d64bfc2d1932f.png 414w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/pngbase64296d64bfc2d1932f-300x70.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9f4ab8f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9f4ab8f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bf64af4\" data-id=\"bf64af4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8033bd6 elementor-widget elementor-widget-text-editor\" data-id=\"8033bd6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Ici en faisant une INNER JOIN entre les deux tables on obtient seulement les id_client qui sont pr\u00e9sents dans la table <\/span><b>email<\/b><span style=\"font-weight: 400;\"> et dans la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\">. Les id_client 4 et 5 qui sont pr\u00e9sents dans la table <\/span><b>email<\/b><span style=\"font-weight: 400;\"> et non dans la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\"> ne sont pas pris en compte. De m\u00eame pour les id_client 7 et 8 qui sont dans la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\"> et non dans la table <\/span><b>email<\/b><span style=\"font-weight: 400;\">. <\/span><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-989bf52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"989bf52\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-511664a\" data-id=\"511664a\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cdc1014 elementor-widget elementor-widget-heading\" data-id=\"cdc1014\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2. LEFT JOIN  <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce90a3d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce90a3d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d7f92c6\" data-id=\"d7f92c6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bbeea35 elementor-widget elementor-widget-text-editor\" data-id=\"bbeea35\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">La jointure \u00e0 gauche ou\u202fLEFT JOIN\u202fest une jointure entre 2 tables qui permet de retourner tous les enregistrements de la table de gauche <\/span><b>m\u00eame s\u2019il n\u2019y a pas de correspondance avec la table de droite<\/b><\/span><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">. S&rsquo;il n&rsquo;y a pas de correspondance, les valeurs manquantes sont d\u00e9finies \u00e0\u202fNULL.\u00a0 Comme pour le INNER JOIN, Il est n\u00e9cessaire de sp\u00e9cifier les attributs \u00e0 utiliser pour effectuer la jointure\u202f:\u00a0 On utilise le mot cl\u00e9\u202fON\u202fsuivi de l&rsquo;\u00e9galit\u00e9 souhait\u00e9e apr\u00e8s avoir renseign\u00e9 les tables dans le LEFT JOIN.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d20a568 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d20a568\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b06bb29\" data-id=\"b06bb29\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-bb6b73d elementor-widget elementor-widget-image\" data-id=\"bb6b73d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"301\" height=\"180\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/Fichier-17.png\" class=\"attachment-full size-full wp-image-65848\" alt=\"jointure gauche sql\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Jointure Gauche (Left Join)<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dca1ce7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dca1ce7\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c85924b\" data-id=\"c85924b\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-624dae7 elementor-widget elementor-widget-text-editor\" data-id=\"624dae7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Ici on fait une requ\u00eate LEFT JOIN par rapport \u00e0 la table <\/span><b>email<\/b><span style=\"font-weight: 400;\"> donc on affiche toutes les lignes lorsque l\u2019id_client est pr\u00e9sent dans la table gauche donc dans la table <\/span><b>email<\/b><span style=\"font-weight: 400;\">.\u00a0\u00a0<\/span><\/span><\/p><p><span style=\"font-weight: 400; color: #000000;\">\u00a0<\/span><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Ainsi les lignes correspondantes \u00e0 l\u2019id_client 7 et 8 ne sont pas pr\u00e9sentes dans la sortie de la requ\u00eate.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aec9843 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aec9843\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-31c4862\" data-id=\"31c4862\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-01580df elementor-widget elementor-widget-shortcode\" data-id=\"01580df\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/EmilieGreff1\/96cd3aa5a2435c4d4622d8cbb550ce76.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6590438 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6590438\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4c1db89\" data-id=\"4c1db89\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0929415 elementor-widget elementor-widget-image\" data-id=\"0929415\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"409\" height=\"119\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-4-1.png\" class=\"attachment-full size-full wp-image-57735\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-4-1.png 409w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-4-1-300x87.png 300w\" sizes=\"(max-width: 409px) 100vw, 409px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9c45a7b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9c45a7b\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7f85cc3\" data-id=\"7f85cc3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6def798 elementor-widget elementor-widget-heading\" data-id=\"6def798\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3. RIGHT JOIN  <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5d425f4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d425f4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d7abad2\" data-id=\"d7abad2\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f3dd0d5 elementor-widget elementor-widget-text-editor\" data-id=\"f3dd0d5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">La jointure \u00e0 droite ou\u202fRIGHT JOIN\u202fest une jointure entre 2 tables qui permet de retourner tous les enregistrements de la table de droite <\/span><b>m\u00eame s\u2019il n\u2019y a pas de correspondance avec la table de gauche<\/b><span style=\"font-weight: 400;\">. S&rsquo;il n&rsquo;y a pas de correspondance, les valeurs manquantes sont d\u00e9finies\u202f\u00e0 NULL.\u00a0<\/span><\/span><\/p><p><span style=\"font-weight: 400; color: #000000;\">Comme pour le INNER JOIN, ou le LEFT JOIN\u00a0 Il est n\u00e9cessaire de sp\u00e9cifier les attributs \u00e0 utiliser pour effectuer la jointure\u202f: on utilise le mot cl\u00e9\u202fON\u202fsuivi de l&rsquo;\u00e9galit\u00e9 souhait\u00e9e apr\u00e8s avoir renseign\u00e9 les tables dans le RIGHT JOIN<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a5233d6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a5233d6\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1692209\" data-id=\"1692209\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-56afbb7 elementor-widget elementor-widget-image\" data-id=\"56afbb7\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"180\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/Fichier-15.png\" class=\"attachment-full size-full wp-image-65849\" alt=\"jointure droite sql\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Jointure droite (Right Join)<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a30b3ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a30b3ac\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1ba5304\" data-id=\"1ba5304\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e2a7e38 elementor-widget elementor-widget-text-editor\" data-id=\"e2a7e38\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">Ici on fait un RIGHT JOIN par rapport \u00e0 la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\">,\u00a0 donc on obtient comme r\u00e9sultat toutes les lignes de la table <\/span><b>ville<\/b><span style=\"font-weight: 400;\"> avec les lignes correspondantes de la table <\/span><b>email<\/b><\/span><span style=\"font-weight: 400;\"><span style=\"color: #000000;\"> lorsqu\u2019il y a correspondance, c\u2019est pourquoi les lignes correspondant \u00e0 l\u2019id_client 4 et 5 ne sont pas pr\u00e9sentes.\u00a0<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-05ddefb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"05ddefb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-168f217\" data-id=\"168f217\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-be13b1e elementor-widget elementor-widget-shortcode\" data-id=\"be13b1e\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/EmilieGreff1\/d77f123da8bfafdc10155e2ac7a0611e.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a7c974f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a7c974f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a1a4e97\" data-id=\"a1a4e97\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-919842b elementor-widget elementor-widget-image\" data-id=\"919842b\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"418\" height=\"108\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-6.png\" class=\"attachment-full size-full wp-image-57754\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-6.png 418w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-6-300x78.png 300w\" sizes=\"(max-width: 418px) 100vw, 418px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ce60fbf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ce60fbf\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02aabb7\" data-id=\"02aabb7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-cfef933 elementor-widget elementor-widget-heading\" data-id=\"cfef933\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">4. FULL JOIN  \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d892041 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d892041\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-865122d\" data-id=\"865122d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1b4233a elementor-widget elementor-widget-text-editor\" data-id=\"1b4233a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">La jointure FULL JOIN est une jointure entre 2 tables qui permet de retourner tous les enregistrements des deux tables m\u00eame s\u2019il n\u2019y a pas de correspondance avec l\u2019autre. S&rsquo;il n&rsquo;y a pas de correspondance, les valeurs manquantes sont d\u00e9finies\u202f\u00e0 NULL. Cette jointure n\u00e9cessite \u00e9galement l\u2019attribut ON.\u00a0<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dba6349 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dba6349\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5fb2a70\" data-id=\"5fb2a70\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-162acf2 elementor-widget elementor-widget-image\" data-id=\"162acf2\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"300\" height=\"180\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/Fichier-16.png\" class=\"attachment-full size-full wp-image-65850\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Union de deux ensembles <\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d09fb95 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d09fb95\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e7f506c\" data-id=\"e7f506c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-98502c9 elementor-widget elementor-widget-text-editor\" data-id=\"98502c9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Ici peu importe s\u2019il n\u2019y a pas de lignes correspondantes dans l\u2019une des deux tables, toutes les informations des deux tables sont pr\u00e9sentes. C\u2019est la jointure qui permet de garder le plus d\u2019informations possibles.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae8ea5d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae8ea5d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e01ef97\" data-id=\"e01ef97\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d34c281 elementor-widget elementor-widget-shortcode\" data-id=\"d34c281\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/EmilieGreff1\/b765e5110d47f5866155cc7b0bb773c2.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f4d930e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f4d930e\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ab04741\" data-id=\"ab04741\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2ff8093 elementor-widget elementor-widget-image\" data-id=\"2ff8093\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"464\" height=\"136\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-8.png\" class=\"attachment-full size-full wp-image-57763\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-8.png 464w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-8-300x88.png 300w\" sizes=\"(max-width: 464px) 100vw, 464px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4bb3df0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4bb3df0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8d08613\" data-id=\"8d08613\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6e9f3f1 elementor-widget elementor-widget-heading\" data-id=\"6e9f3f1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5. NATURAL JOIN  <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ea6ef90 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ea6ef90\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-468d505\" data-id=\"468d505\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab5b50f elementor-widget elementor-widget-text-editor\" data-id=\"ab5b50f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">La jointure\u00a0 NATURAL JOIN est une jointure entre 2 tables qui permet de retourner les enregistrements des deux tables de fa\u00e7on \u00ab\u202fnaturelle\u202f\u00bb.\u00a0 Il faut qu\u2019il y ait au moins une colonne avec le m\u00eame nom dans les deux tables. Elle permet de faire une jointure naturelle en retournant les lignes o\u00f9 il y a des paires qui correspondent aux deux tables.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Avec NATURAL JOIN on ne sp\u00e9cifie pas le ON.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-aca1aa4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"aca1aa4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-de989d4\" data-id=\"de989d4\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e848a8a elementor-widget elementor-widget-shortcode\" data-id=\"e848a8a\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-shortcode\"><script src=\"https:\/\/gist.github.com\/EmilieGreff1\/2870c540434de8ab3165b74edfce5b40.js\"><\/script><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b84211d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b84211d\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2bbc781\" data-id=\"2bbc781\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ad4b48d elementor-widget elementor-widget-image\" data-id=\"ad4b48d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"414\" height=\"97\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-9.png\" class=\"attachment-full size-full wp-image-57766\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-9.png 414w, https:\/\/datascientest.com\/wp-content\/uploads\/2021\/03\/unnamed-9-300x70.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bf08321 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf08321\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d8ee7c3\" data-id=\"d8ee7c3\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1f8c312 elementor-widget elementor-widget-text-editor\" data-id=\"1f8c312\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #000000;\">On voit \u00e0 la sortie qu\u2019il y a bien eu une jointure entre les deux tables avec \u00ab\u202fid_client\u202f\u00bb car c\u2019est la seule variable pr\u00e9sente dans les deux tables.\u00a0<\/span><\/p><p><span style=\"color: #000000;\"><b>Mais quelle est la diff\u00e9rence entre la NATURAL JOIN et la INNER JOIN\u202f?\u00a0\u00a0<\/b><\/span><\/p><p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">La INNER JOIN permet d\u2019\u00e9viter la r\u00e9p\u00e9tition de lignes \u00e9gales, ce que ne permet pas la NATURAL JOIN. La jointure interne renvoie une table en fonction des donn\u00e9es sp\u00e9cifi\u00e9es dans le ON alors que la jointure naturelle renvoie une table en fonction d&rsquo;une colonne avec le m\u00eame nom et le m\u00eame type dans les deux tables.\u00a0\u00a0<\/span><\/span><\/p><p><span style=\"color: #000000;\"><span style=\"font-weight: 400;\">\u00a0<\/span><span style=\"font-weight: 400;\">Les quatre types de jointures SQL \u00e0 retenir sont\u202f:\u00a0\u00a0<\/span><\/span><\/p><ul><li><span style=\"font-weight: 400; color: #000000;\">INNER JOIN qui permet de r\u00e9cup\u00e9rer les informations entre deux tables lorsque la condition sur le ON est respect\u00e9e sur les deux tables,\u00a0<\/span><\/li><li><span style=\"font-weight: 400; color: #000000;\">LEFT \/ RIGHT JOIN qui permet de r\u00e9cup\u00e9rer les informations entre deux tables en gardant toutes les informations de l\u2019une des deux tables,\u00a0<\/span><\/li><li><span style=\"font-weight: 400; color: #000000;\">FULL JOIN r\u00e9cup\u00e8re toutes les informations des deux tables sans perte d\u2019information (mais elle peut afficher beaucoup de NULL),\u00a0<\/span><\/li><li><span style=\"font-weight: 400; color: #000000;\">NATURAL JOIN effectue une jointure naturelle entre les deux tables, on n\u2019a pas besoin de sp\u00e9cifier le ON.\u00a0\u00a0<\/span><\/li><\/ul><p><span style=\"font-weight: 400; color: #000000;\">\u00a0<\/span><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Les jointures permettent d\u2019associer plusieurs tables de mani\u00e8re efficace. Il en existe plusieurs types et nous en avons vu les principales. Si vous souhaitez conna\u00eetre les\u00a0<\/span><\/span><a href=\"https:\/\/datascientest.com\/tuto-sql\" target=\"_blank\" rel=\"noopener\">5 m\u00e9thodes les plus utiles en SQL, d\u00e9couvrez cet article<\/a><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">\u00a0.\u00a0<\/span><\/span><\/p><p><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">Si vous souhaitez en savoir plus concernant les requ\u00eates SQL un module y est consacr\u00e9 dans notre<\/span><\/span><a href=\"https:\/\/datascientest.com\/formation-data-analyst\" target=\"_blank\" rel=\"noopener\"> formation de Data Analyst<\/a><span style=\"font-weight: 400;\"><span style=\"color: #000000;\">.<\/span> <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-71fa5bc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71fa5bc\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ca98916\" data-id=\"ca98916\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-24f1ea1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"24f1ea1\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Je d\u00e9couvre le parcours Data Analyst<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t<div class=\"elementor-element elementor-element-3234465 e-flex e-con-boxed e-con\" data-id=\"3234465\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cc8690e elementor-widget elementor-widget-html\" data-id=\"cc8690e\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que INNER JOIN ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La jointure interne ou INNER JOIN permet de retourner les donn\u00e9es quand la condition est vraie dans les deux tables.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que \u202fLEFT JOIN ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La jointure \u00e0 gauche ou\u202fLEFT JOIN\u202fest une jointure entre 2 tables qui permet de retourner tous les enregistrements de la table de gauche m\u00eame s\u2019il n\u2019y a pas de correspondance avec la table de droite.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que \u202fRIGHT JOIN ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La jointure \u00e0 droite ou\u202fRIGHT JOIN\u202fest une jointure entre 2 tables qui permet de retourner tous les enregistrements de la table de droite m\u00eame s\u2019il n\u2019y a pas de correspondance avec la table de gauche. S\u2019il n\u2019y a pas de correspondance, les valeurs manquantes sont d\u00e9finies\u202f\u00e0 NULL.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que FULL JOIN ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La jointure FULL JOIN est une jointure entre 2 tables qui permet de retourner tous les enregistrements des deux tables m\u00eame s\u2019il n\u2019y a pas de correspondance avec l\u2019autre. S\u2019il n\u2019y a pas de correspondance, les valeurs manquantes sont d\u00e9finies\u202f\u00e0 NULL. Cette jointure n\u00e9cessite \u00e9galement l\u2019attribut ON.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est ce que NATURAL JOIN ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La jointure  NATURAL JOIN est une jointure entre 2 tables qui permet de retourner les enregistrements des deux tables de fa\u00e7on \u00ab\u202fnaturelle\u202f\u00bb.  Il faut qu\u2019il y ait au moins une colonne avec le m\u00eame nom dans les deux tables. Elle permet de faire une jointure naturelle en retournant les lignes o\u00f9 il y a des paires qui correspondent aux deux tables.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Si vous \u00eates fid\u00e8le \u00e0 notre blog, vous avez d\u00e9j\u00e0 entendu parler de SQL ou \u201cStructured Query Language\u201d: langage de programmation pour g\u00e9rer des bases de donn\u00e9es et vous \u00eates au courant de l\u2019importance des jointures SQL.&nbsp; Si vous avez manqu\u00e9 l\u2019article pour&nbsp;conna\u00eetre les bases du langage SQL. On vous le redonnes ici. A premi\u00e8re [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":65843,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Jointures SQL : tout comprendre sur l&#039;association de tables<\/title>\n<meta name=\"description\" content=\"D\u00e9couvrez avec un de nos experts tout ce qu&#039;il faut savoir sur les jointures SQL : Elles permettent d&#039;associer de nombreuses tables\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jointures SQL : tout comprendre sur l&#039;association de tables\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-04T08:07:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T14:07:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/illu_jointureSQL_blog-145.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql\",\"url\":\"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql\",\"name\":\"Jointures SQL : tout comprendre sur l'association de tables\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2021-05-04T08:07:52+00:00\",\"dateModified\":\"2023-11-09T14:07:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"D\u00e9couvrez avec un de nos experts tout ce qu'il faut savoir sur les jointures SQL : Elles permettent d'associer de nombreuses tables\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Jointures SQL : tout comprendre sur l'association de tables","description":"D\u00e9couvrez avec un de nos experts tout ce qu'il faut savoir sur les jointures SQL : Elles permettent d'associer de nombreuses tables","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:\/\/datascientest.com\/tout-comprendre-des-jointures-sql","og_locale":"fr_FR","og_type":"article","og_title":"Jointures SQL : tout comprendre sur l'association de tables","og_url":"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2021-05-04T08:07:52+00:00","article_modified_time":"2023-11-09T14:07:23+00:00","og_image":[{"width":1024,"height":562,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2021\/04\/illu_jointureSQL_blog-145.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql","url":"https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql","name":"Jointures SQL : tout comprendre sur l'association de tables","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2021-05-04T08:07:52+00:00","dateModified":"2023-11-09T14:07:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"D\u00e9couvrez avec un de nos experts tout ce qu'il faut savoir sur les jointures SQL : Elles permettent d'associer de nombreuses tables","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/tout-comprendre-des-jointures-sql"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/57687"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=57687"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/57687\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/65843"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=57687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=57687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=57687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}