{"id":10987,"date":"2023-02-14T21:19:49","date_gmt":"2023-02-14T20:19:49","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=10987"},"modified":"2023-11-01T19:41:47","modified_gmt":"2023-11-01T18:41:47","slug":"jointures-sql","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=10987","title":{"rendered":"Analyse de donn\u00e9es et automatisation avec Excel et Access (10\u00e8me volet)"},"content":{"rendered":"<p style=\"text-align: justify;\">Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation, le huiti\u00e8me volet \u00e0 la d\u00e9couverte du logiciel de gestion de bases de donn\u00e9es Access. Le neuvi\u00e8me volet a ouvert le sujet des requ\u00eates SQL. Ce dixi\u00e8me volet le continue. Il ne traite que des <strong>jointures<\/strong> mais le menu est bien copieux.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11036\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures.png\" alt=\"Volet 10 SQL Jointures\" width=\"1032\" height=\"791\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures.png 1032w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures-300x230.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures-1024x785.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures-768x589.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/Volet-10-SQL-Jointures-730x560.png 730w\" sizes=\"auto, (max-width: 1032px) 100vw, 1032px\" \/><\/p>\n<p style=\"text-align: justify;\">Une jointure (<strong>JOIN<\/strong>) permet de lier plusieurs tables (ou r\u00e9sultats de requ\u00eates) entre elles. Il existe plusieurs types de jointures : jointures internes (<strong>INNER<\/strong>), gauche (<strong>LEFT<\/strong>) et droite (<strong>RIGHT<\/strong>), avec ou sans <strong>intersection<\/strong>.<\/p>\n<p style=\"text-align: justify;\">La correspondance entre les tables est d\u00e9finie par l\u2019instruction <strong>ON<\/strong> suivie du <strong>nom des champs<\/strong> des tables associ\u00e9es par JOIN.<\/p>\n<p style=\"text-align: justify;\">Exemple : \u2026 ON TClients.CompteAuxNum = TFactures.CompteAuxNum<\/p>\n<p style=\"text-align: justify;\">Syntaxe : SELECT\u2026 FROM Table1 INNER\/LEFT\/RIGHT JOIN Table2 ON\u2026<\/p>\n<p style=\"text-align: justify;\">Si certaines tables parties \u00e0 la jointure ne sont pas dans la m\u00eame base de donn\u00e9es, indiquer le chemin et le nom de la base de donn\u00e9es :<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">SELECT\u2026\r\n\r\nFROM ['C:\\base.accdb\u2019].PlanComptable \u2026 JOIN\u2026;<\/pre>\n<p style=\"text-align: justify;\">La r\u00e9daction &#8220;FROM PlanComptable IN &#8216;C:\\base.accdb\u2019;&#8221; (d\u00e9j\u00e0 pr\u00e9sent\u00e9e pr\u00e9c\u00e9demment) ne sera pas op\u00e9rationnelle dans le cas de jointures.<\/p>\n<p style=\"text-align: justify;\">Pour d\u00e9couvrir le langage SQL, t\u00e9l\u00e9charger le support de formation PDF gratuitement ci-apr\u00e8s.<\/p>\n<p style=\"text-align: justify;\">Le prochain volet approfondira le sujet du langage SQL avec les fonctions SQL, les champs calcul\u00e9s et les structures conditionnelles.<\/p>\n<p style=\"text-align: justify;\">Besoin d&#8217;aide ? Envie d&#8217;innover ? Et si vous consultiez ChatGPT ? ChatGPT (OpenAI) est le ph\u00e9nom\u00e8ne IA du moment. SQL, VBA, formule Excel, lettre de motivation ? ChatGPT est omniscient (sauf quand il se trompe). <a href=\"https:\/\/www.auditsi.eu\/?p=10976\">Tester ChatGPT<\/a> ou se former \u00e0 l&#8217;<a href=\"https:\/\/www.auditsi.eu\/?p=10976\">intelligence artificielle<\/a> (IA). Exemple de r\u00e9ponse de ChatGPT \u00e0 une demande :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11037\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/ChatGPT-SQL-Jointure.png\" alt=\"ChatGPT SQL Jointure\" width=\"752\" height=\"885\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/ChatGPT-SQL-Jointure.png 752w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/ChatGPT-SQL-Jointure-255x300.png 255w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2023\/02\/ChatGPT-SQL-Jointure-730x859.png 730w\" sizes=\"auto, (max-width: 752px) 100vw, 752px\" \/><\/p>\n<p style=\"text-align: justify;\">___<\/p>\n<p style=\"text-align: justify;\">Retrouver&nbsp;<a href=\"https:\/\/www.auditsi.eu\/?cat=2765\">tous les volets de cette s\u00e9rie<\/a> d\u00e9di\u00e9e \u00e0 l\u2019analyse de donn\u00e9es et \u00e0 l\u2019automatisation avec Excel et Access<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%2810%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>Les quatre premiers volets de cette formation ont \u00e9t\u00e9 consacr\u00e9s \u00e0 Excel, les trois suivants au langage VBA et l\u2019automatisation, le huiti\u00e8me volet \u00e0 la d\u00e9couverte du logiciel de gestion de bases de donn\u00e9es Access. Le neuvi\u00e8me volet a ouvert le sujet des requ\u00eates SQL. Ce dixi\u00e8me volet le continue. Il ne traite que des &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=10987\" class=\"more-link\">Continue reading &lsquo;Analyse de donn\u00e9es et automatisation avec Excel et Access (10\u00e8me volet)&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Analyse%20de%20donn%C3%A9es%20et%20automatisation%20avec%20Excel%20et%20Access%20%2810%C3%A8me%20volet%29\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[2765,641,282],"tags":[60,284,2872,2900,2897,2901,687,2898,2902,2719,57,2899,1643],"class_list":["post-10987","post","type-post","status-publish","format-standard","hentry","category-analyse-de-donnees-et-automatisation-avec-excel-et-access","category-formation-professionnelle","category-sql","tag-access","tag-as","tag-chatgpt","tag-in","tag-inner-join","tag-intersection","tag-jointure","tag-left-join","tag-null","tag-requete","tag-requete-sql","tag-right-join","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10987","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10987"}],"version-history":[{"count":6,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10987\/revisions"}],"predecessor-version":[{"id":11039,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/10987\/revisions\/11039"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10987"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10987"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10987"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}