{"id":1101,"date":"2026-07-15T22:40:45","date_gmt":"2026-07-15T20:40:45","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=1101"},"modified":"2026-07-15T22:40:45","modified_gmt":"2026-07-15T20:40:45","slug":"requetes-sql","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=1101","title":{"rendered":"Requetes SQL"},"content":{"rendered":"\n<h1 id=\"but-du-document\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"But_du_document\"><\/span>But du document<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Ce document a pour but de montrer comment&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Cr\u00e9er des requ\u00eates simples<\/li>\n\n\n\n<li>Comment relier 2 tables dans une requ\u00eate<\/li>\n\n\n\n<li>Optimiser les requ\u00eates<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons donc utiliser les tables cr\u00e9\u00e9es dans l\u2019article \u00a0<a href=\"https:\/\/communaute-omr.fr\/?p=1094\" data-type=\"link\" data-id=\"https:\/\/communaute-omr.fr\/?p=1094\" target=\"_blank\" rel=\"noreferrer noopener\">pr\u00e9c\u00e9dent<\/a>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Codepostal<\/li>\n\n\n\n<li>Ville<\/li>\n<\/ul>\n\n\n\n<!--more-->\n\n\n\n<h1 id=\"requetes-simples\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Requetes_simples\"><\/span>Requ\u00eates simples<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"sans-critere\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sans_critere\"><\/span>Sans crit\u00e8re<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Le select ci-dessous affiche toutes les lignes de la table&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select * from codepostal;\n+-------+-------+------------+-------------------------+\n| cp_id | Insee | codepostal | Acheminement            |\n+-------+-------+------------+-------------------------+\n|     1 | 01001 | 01400      | L ABERGEMENT CLEMENCIAT |\n|     2 | 01002 | 01640      | L ABERGEMENT DE VAREY   |\n|     3 | 01004 | 01500      | AMBERIEU EN BUGEY       |\n|     4 | 01005 | 01330      | AMBERIEUX EN DOMBES     |\n|     5 | 01006 | 01300      | AMBLEON                 |\n|     6 | 01007 | 01500      | AMBRONAY                |\n|     7 | 01008 | 01500      | AMBUTRIX                |\n|     8 | 01009 | 01300      | ANDERT ET CONDON        |\n|     9 | 01010 | 01350      | ANGLEFORT               |\n|    10 | 01011 | 01100      | APREMONT                |\n|    11 | 01012 | 01110      | ARANC                   |\n|    12 | 01013 | 01230      | ARANDAS                 |\n|    13 | 01014 | 01100      | ARBENT                  |\n|    14 | 01015 | 01300      | ARBOYS EN BUGEY         |\n|    15 | 01016 | 01190      | ARBIGNY                 |\n|    16 | 01017 | 01230      | ARGIS                   |\n|    17 | 01019 | 01510      | ARMIX                   |\n|    18 | 01021 | 01480      | ARS SUR FORMANS         |\n|    19 | 01022 | 01510      | ARTEMARE                |\n...\n| 35601 | 98817 | 98874      | PONT DES FRANCAIS       |\n| 35602 | 98817 | 98875      | PLUM                    |\n| 35603 | 98817 | 98876      | LA COULEE               |\n| 35604 | 98818 | 98800      | NOUMEA                  |\n| 35605 | 98819 | 98821      | OUEGOA                  |\n| 35606 | 98820 | 98814      | FAYAOUE                 |\n| 35607 | 98821 | 98840      | TONTOUTA                |\n| 35608 | 98821 | 98889      | PAITA                   |\n| 35609 | 98821 | 98890      | PAITA                   |\n| 35610 | 98822 | 98822      | POINDIMIE               |\n| 35611 | 98823 | 98823      | PONERIHOUEN             |\n| 35612 | 98824 | 98824      | POUEBO                  |\n| 35613 | 98825 | 98825      | POUEMBOUT               |\n| 35614 | 98826 | 98826      | POUM                    |\n| 35615 | 98827 | 98827      | POYA                    |\n| 35616 | 98827 | 98877      | NEPOUI                  |\n| 35617 | 98828 | 98882      | SARRAMEA                |\n| 35618 | 98829 | 98829      | THIO                    |\n| 35619 | 98830 | 98831      | TOUHO                   |\n| 35620 | 98831 | 98833      | VOH                     |\n| 35621 | 98831 | 98883      | OUACO                   |\n| 35622 | 98832 | 98834      | YATE                    |\n| 35623 | 98833 | 98818      | KOUAOUA                 |\n| 35624 | 98901 | 98799      | ILE DE CLIPPERTON       |\n| 35625 | 99138 | 98000      | MONACO                  |\n+-------+-------+------------+-------------------------+\n35625 rows in set (0.00 sec)rows in set (0.00 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> codepostal;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------+-------+------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| cp_id | Insee | codepostal | Acheminement            |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------+-------+------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01001<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01400<\/span><span style=\"color: #E1E4E8\">      | L ABERGEMENT CLEMENCIAT |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01002<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01640<\/span><span style=\"color: #E1E4E8\">      | L ABERGEMENT DE VAREY   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">3<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01004<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01500<\/span><span style=\"color: #E1E4E8\">      | AMBERIEU EN BUGEY       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">4<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01005<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01330<\/span><span style=\"color: #E1E4E8\">      | AMBERIEUX EN DOMBES     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01006<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01300<\/span><span style=\"color: #E1E4E8\">      | AMBLEON                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">6<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01007<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01500<\/span><span style=\"color: #E1E4E8\">      | AMBRONAY                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">7<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01008<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01500<\/span><span style=\"color: #E1E4E8\">      | AMBUTRIX                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">8<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01009<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01300<\/span><span style=\"color: #E1E4E8\">      | ANDERT ET CONDON        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">9<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01010<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01350<\/span><span style=\"color: #E1E4E8\">      | ANGLEFORT               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">10<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01011<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01100<\/span><span style=\"color: #E1E4E8\">      | APREMONT                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01012<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01110<\/span><span style=\"color: #E1E4E8\">      | ARANC                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01013<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01230<\/span><span style=\"color: #E1E4E8\">      | ARANDAS                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01014<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01100<\/span><span style=\"color: #E1E4E8\">      | ARBENT                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">14<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01015<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01300<\/span><span style=\"color: #E1E4E8\">      | ARBOYS EN BUGEY         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">15<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01016<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01190<\/span><span style=\"color: #E1E4E8\">      | ARBIGNY                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">16<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01017<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01230<\/span><span style=\"color: #E1E4E8\">      | ARGIS                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">17<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01019<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01510<\/span><span style=\"color: #E1E4E8\">      | ARMIX                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">18<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01021<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01480<\/span><span style=\"color: #E1E4E8\">      | ARS SUR FORMANS         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">19<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01022<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">01510<\/span><span style=\"color: #E1E4E8\">      | ARTEMARE                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">...<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35601<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98817<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98874<\/span><span style=\"color: #E1E4E8\">      | PONT <\/span><span style=\"color: #F97583\">DES<\/span><span style=\"color: #E1E4E8\"> FRANCAIS       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35602<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98817<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98875<\/span><span style=\"color: #E1E4E8\">      | PLUM                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35603<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98817<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98876<\/span><span style=\"color: #E1E4E8\">      | LA COULEE               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35604<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98818<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98800<\/span><span style=\"color: #E1E4E8\">      | NOUMEA                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35605<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98819<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98821<\/span><span style=\"color: #E1E4E8\">      | OUEGOA                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35606<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98820<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98814<\/span><span style=\"color: #E1E4E8\">      | FAYAOUE                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35607<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98821<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98840<\/span><span style=\"color: #E1E4E8\">      | TONTOUTA                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35608<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98821<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98889<\/span><span style=\"color: #E1E4E8\">      | PAITA                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35609<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98821<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98890<\/span><span style=\"color: #E1E4E8\">      | PAITA                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35610<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98822<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98822<\/span><span style=\"color: #E1E4E8\">      | POINDIMIE               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35611<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98823<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98823<\/span><span style=\"color: #E1E4E8\">      | PONERIHOUEN             |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35612<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98824<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98824<\/span><span style=\"color: #E1E4E8\">      | POUEBO                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35613<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98825<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98825<\/span><span style=\"color: #E1E4E8\">      | POUEMBOUT               |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35614<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98826<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98826<\/span><span style=\"color: #E1E4E8\">      | POUM                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35615<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98827<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98827<\/span><span style=\"color: #E1E4E8\">      | POYA                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35616<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98827<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98877<\/span><span style=\"color: #E1E4E8\">      | NEPOUI                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35617<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98828<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98882<\/span><span style=\"color: #E1E4E8\">      | SARRAMEA                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35618<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98829<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98829<\/span><span style=\"color: #E1E4E8\">      | THIO                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35619<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98830<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98831<\/span><span style=\"color: #E1E4E8\">      | TOUHO                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35620<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98831<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98833<\/span><span style=\"color: #E1E4E8\">      | VOH                     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35621<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98831<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98883<\/span><span style=\"color: #E1E4E8\">      | OUACO                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35622<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98832<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98834<\/span><span style=\"color: #E1E4E8\">      | YATE                    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35623<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98833<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98818<\/span><span style=\"color: #E1E4E8\">      | KOUAOUA                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35624<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98901<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98799<\/span><span style=\"color: #E1E4E8\">      | ILE DE CLIPPERTON       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">35625<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">99138<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">98000<\/span><span style=\"color: #E1E4E8\">      | MONACO                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------+-------+------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">35625<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">00<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">00<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"avec-critere\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Avec_critere\"><\/span>Avec crit\u00e8re<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons voir comment utiliser la clause where<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons faire plusieurs requ\u00eates&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Toutes les villes portant m\u00eame nom<\/li>\n\n\n\n<li>Toutes les villes ayant une partie du nom en commun<\/li>\n<\/ul>\n\n\n\n<h3 id=\"ville-ayant-le-meme-nom\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ville_ayant_le_meme_nom\"><\/span>Ville ayant le m\u00eame nom<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons utiliser la clause where basiquement en indiquant comme crit\u00e8re&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Le nom du champ<\/li>\n\n\n\n<li>L\u2019expression exacte recherch\u00e9e<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Gr\u00e2ce \u00e0 cette requ\u00eate nous savons qu\u2019il y a 3 villes en France qui s\u2019appellent Bellegarde.&nbsp; \ud83d\ude1b<\/p>\n\n\n\n<h3 id=\"dautres-villes-peuvent-elles-avoir-ce-nom-de-ville-dans-leur-nom\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Dautres_villes_peuvent-elles_avoir_ce_nom_de_ville_dans_leur_nom\"><\/span>D\u2019autres villes peuvent-elles avoir ce nom de ville dans leur nom<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons maintenant rajouter le discriminant  \u00ab&nbsp;=&nbsp;\u00bb like dans une expression r\u00e9guli\u00e8re&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select * \nfrom ville \nwhere Name like \"%Bellegarde%\";<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\"> <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> ville <\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">where<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">Name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">like<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;%Bellegarde%&quot;<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>+----------+-------+-----------------------------+\n| ville_id | cp_id | Name                       |\n+----------+-------+-----------------------------+\n|     3628 |  3628 | Bellegarde Du Razes         |\n|     7724 |  7724 | Bellegarde En Marche        |\n|     7935 |  7935 | St Silvain Bellegarde       |\n|     8291 |  8291 | St Barthelemy De Bellegarde |\n|     9087 |  9087 | Bellegarde En Diois         |\n|    11063 | 11063 | Bellegarde                  |\n|    11440 | 11440 | Bellegarde Ste Marie        |\n|    12011 | 12011 | Bellegarde                  |\n|    14204 | 14204 | Bellegarde Poussieu         |\n|    15808 | 15808 | Bellegarde En Forez         |\n|    16620 | 16620 | Bellegarde                  |\n|    16819 | 16819 | Ouzouer Sous Bellegarde     |\n|    32148 | 32148 | Bellegarde Marsal           |\n+----------+-------+-----------------------------+\n13 rows in set (0.23 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| ville_id | cp_id | <\/span><span style=\"color: #F97583\">Name<\/span><span style=\"color: #E1E4E8\">                       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">3628<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">3628<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Du Razes         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">7724<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">7724<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Marche        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">7935<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">7935<\/span><span style=\"color: #E1E4E8\"> | St Silvain Bellegarde       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">8291<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">8291<\/span><span style=\"color: #E1E4E8\"> | St Barthelemy De Bellegarde |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">9087<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">9087<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Diois         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">11063<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">11063<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">11440<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">11440<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Ste Marie        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">12011<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">12011<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">14204<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">14204<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Poussieu         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">15808<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">15808<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Forez         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">16620<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">16620<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">16819<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">16819<\/span><span style=\"color: #E1E4E8\"> | Ouzouer Sous Bellegarde     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">32148<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">32148<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Marsal           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">23<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Bonne nouvelle 13 Villes en France ont Bellegarde dans leur nom.&nbsp;\ud83d\ude00<\/p>\n\n\n\n<h1 id=\"relier-des-tables-entre-elles-et-filtrer-la-sortie\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Relier_des_tables_entre_elles_et_filtrer_la_sortie\"><\/span>Relier des tables entre elles et filtrer la sortie<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"requetes-parallelisees\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Requetes_parallelisees\"><\/span>Requ\u00eates parall\u00e9lis\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Il est d\u00e9conseill\u00e9 d\u2019utiliser cette m\u00e9thode sur des grosse base de donn\u00e9es car elle est tr\u00e8s consommatrice de ressource syst\u00e8me<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons partir de la derni\u00e8re requ\u00eate pour afficher le code postal de chaque ville<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select *\nfrom ville\nwhere cp_id IN (\nSELECT cp_id\nFROM cp\nWHERE cp.cp_id=ville.cp_id)\nAND Name like \"%Bellegarde%\"\norder by name\n;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">*<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> ville<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">where<\/span><span style=\"color: #E1E4E8\"> cp_id <\/span><span style=\"color: #F97583\">IN<\/span><span style=\"color: #E1E4E8\"> (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">SELECT<\/span><span style=\"color: #E1E4E8\"> cp_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">FROM<\/span><span style=\"color: #E1E4E8\"> cp<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">cp<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #79B8FF\">ville<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">AND<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">Name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">like<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;%Bellegarde%&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">order by<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">name<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Le r\u00e9sultat n\u2019est pas \u00e0 la hauteur de nos attentes&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>+----------+-------+-----------------------------+\n| ville_id | cp_id | Name                        |\n+----------+-------+-----------------------------+\n|    11063 | 11063 | Bellegarde                  |\n|    12011 | 12011 | Bellegarde                  |\n|    16620 | 16620 | Bellegarde                  |\n|     3628 |  3628 | Bellegarde Du Razes         |\n|     9087 |  9087 | Bellegarde En Diois         |\n|    15808 | 15808 | Bellegarde En Forez         |\n|     7724 |  7724 | Bellegarde En Marche        |\n|    32148 | 32148 | Bellegarde Marsal           |\n|    14204 | 14204 | Bellegarde Poussieu         |\n|    11440 | 11440 | Bellegarde Ste Marie        |\n|    16819 | 16819 | Ouzouer Sous Bellegarde     |\n|     8291 |  8291 | St Barthelemy De Bellegarde |\n|     7935 |  7935 | St Silvain Bellegarde       |\n+----------+-------+-----------------------------+\n13 rows in set (0.28 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| ville_id | cp_id | <\/span><span style=\"color: #F97583\">Name<\/span><span style=\"color: #E1E4E8\">                        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">11063<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">11063<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">12011<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">12011<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">16620<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">16620<\/span><span style=\"color: #E1E4E8\"> | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">3628<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">3628<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Du Razes         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">9087<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">9087<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Diois         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">15808<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">15808<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Forez         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">7724<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">7724<\/span><span style=\"color: #E1E4E8\"> | Bellegarde En Marche        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">32148<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">32148<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Marsal           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">14204<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">14204<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Poussieu         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">11440<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">11440<\/span><span style=\"color: #E1E4E8\"> | Bellegarde Ste Marie        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">16819<\/span><span style=\"color: #E1E4E8\"> | <\/span><span style=\"color: #79B8FF\">16819<\/span><span style=\"color: #E1E4E8\"> | Ouzouer Sous Bellegarde     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">8291<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">8291<\/span><span style=\"color: #E1E4E8\"> | St Barthelemy De Bellegarde |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|     <\/span><span style=\"color: #79B8FF\">7935<\/span><span style=\"color: #E1E4E8\"> |  <\/span><span style=\"color: #79B8FF\">7935<\/span><span style=\"color: #E1E4E8\"> | St Silvain Bellegarde       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+-------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">28<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"utilisation-des-jointures\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Utilisation_des_jointures\"><\/span>Utilisation des jointures<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons voir l\u2019utilisation des jointures et comparer le r\u00e9sultat avec la requ\u00eate pr\u00e9c\u00e9dente.<\/p>\n\n\n\n<h3 id=\"rechercher-les-codes-postaux-par-ville\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Rechercher_les_codes_postaux_par_ville\"><\/span>Rechercher les codes postaux par ville<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select ZIP.codepostal as \"code postal\", TOWN.name AS \"Ville\"\nfrom ville AS TOWN\nLEFT JOIN cp AS ZIP ON ZIP.cp_id=TOWN.cp_id\nWHERE Name like \"%Bellegarde%\"\norder by ZIP.codepostal,TOWN.name;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">ZIP<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">codepostal<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">as<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;code postal&quot;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;Ville&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> ville <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> TOWN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">LEFT JOIN<\/span><span style=\"color: #E1E4E8\"> cp <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> ZIP <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">ZIP<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">Name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">like<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;%Bellegarde%&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">order by<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">ZIP<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">codepostal<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">name<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">R\u00e9sultat&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>+-------------+-----------------------------+\n| code postal | Ville                       |\n+-------------+-----------------------------+\n| 11240       | Bellegarde Du Razes         |\n| 23190       | Bellegarde En Marche        |\n| 23190       | St Silvain Bellegarde       |\n| 24700       | St Barthelemy De Bellegarde |\n| 26470       | Bellegarde En Diois         |\n| 30127       | Bellegarde                  |\n| 31530       | Bellegarde Ste Marie        |\n| 32140       | Bellegarde                  |\n| 38270       | Bellegarde Poussieu         |\n| 42210       | Bellegarde En Forez         |\n| 45270       | Bellegarde                  |\n| 45270       | Ouzouer Sous Bellegarde     |\n| 81430       | Bellegarde Marsal           |\n+-------------+-----------------------------+\n13 rows in set (0.24 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| code postal | Ville                       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">11240<\/span><span style=\"color: #E1E4E8\">       | Bellegarde Du Razes         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">23190<\/span><span style=\"color: #E1E4E8\">       | Bellegarde En Marche        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">23190<\/span><span style=\"color: #E1E4E8\">       | St Silvain Bellegarde       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">24700<\/span><span style=\"color: #E1E4E8\">       | St Barthelemy De Bellegarde |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">26470<\/span><span style=\"color: #E1E4E8\">       | Bellegarde En Diois         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">30127<\/span><span style=\"color: #E1E4E8\">       | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">31530<\/span><span style=\"color: #E1E4E8\">       | Bellegarde Ste Marie        |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">32140<\/span><span style=\"color: #E1E4E8\">       | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">38270<\/span><span style=\"color: #E1E4E8\">       | Bellegarde Poussieu         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">42210<\/span><span style=\"color: #E1E4E8\">       | Bellegarde En Forez         |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Bellegarde                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Ouzouer Sous Bellegarde     |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">81430<\/span><span style=\"color: #E1E4E8\">       | Bellegarde Marsal           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-----------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">13<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">24<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"rechercher-les-villes-par-code-postal\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Rechercher_les_villes_par_code_postal\"><\/span>Rechercher les villes par code postal<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select ZIP.codepostal as \"code postal\", TOWN.name AS \"Ville\"\nfrom ville AS TOWN\nLEFT JOIN cp AS ZIP ON ZIP.cp_id=TOWN.cp_id\n-- WHERE Name like \"%Bellegarde%\"\nWHERE codepostal=45270\norder by TOWN.name;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">ZIP<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">codepostal<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">as<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;code postal&quot;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">name<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">&quot;Ville&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> ville <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> TOWN<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">LEFT JOIN<\/span><span style=\"color: #E1E4E8\"> cp <\/span><span style=\"color: #F97583\">AS<\/span><span style=\"color: #E1E4E8\"> ZIP <\/span><span style=\"color: #F97583\">ON<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">ZIP<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">cp_id<\/span><\/span>\n<span class=\"line\"><span style=\"color: #6A737D\">-- WHERE Name like &quot;%Bellegarde%&quot;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">WHERE<\/span><span style=\"color: #E1E4E8\"> codepostal<\/span><span style=\"color: #F97583\">=<\/span><span style=\"color: #79B8FF\">45270<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">order by<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">TOWN<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">name<\/span><span style=\"color: #E1E4E8\">;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">R\u00e9sultat&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>+-------------+-------------------------+\n| code postal | Ville                   |\n+-------------+-------------------------+\n| 45270       | Auvilliers En Gatinais  |\n| 45270       | Beauchamps Sur Huillard |\n| 45270       | Bellegarde              |\n| 45270       | Chapelon                |\n| 45270       | Freville Du Gatinais    |\n| 45270       | Ladon                   |\n| 45270       | Mezieres En Gatinais    |\n| 45270       | Moulon                  |\n| 45270       | Nesploy                 |\n| 45270       | Ouzouer Sous Bellegarde |\n| 45270       | Quiers Sur Bezonde      |\n| 45270       | Villemoutiers           |\n+-------------+-------------------------+\n12 rows in set (0.21 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| code postal | Ville                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Auvilliers En Gatinais  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Beauchamps Sur Huillard |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Bellegarde              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Chapelon                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Freville Du Gatinais    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Ladon                   |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Mezieres En Gatinais    |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Moulon                  |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Nesploy                 |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Ouzouer Sous Bellegarde |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Quiers Sur Bezonde      |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">45270<\/span><span style=\"color: #E1E4E8\">       | Villemoutiers           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">-------------+-------------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">12<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">21<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"conclusion\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Les jointures sont&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Beaucoup plus souples \u00e0 utiliser<\/li>\n\n\n\n<li>Le temps de r\u00e9ponse est grandement am\u00e9lior\u00e9<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Temps d\u2019ex\u00e9cution de la requ\u00eate inf\u00e9rieur a 20% via les jointures pour remonter seulement 15 lignes. Je vous laisse imaginer le gain de temps quand il s\u2019agis de remonter des dizaines de millier de lignes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>But du document Ce document a pour but de montrer comment&nbsp;: Nous allons donc utiliser les tables cr\u00e9\u00e9es dans l\u2019article \u00a0pr\u00e9c\u00e9dent:<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[34,35],"tags":[],"class_list":["post-1101","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees","category-mysql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/communaute-omr.fr\/?author=1"},"uagb_comment_info":0,"uagb_excerpt":"But du document Ce document a pour but de montrer comment&nbsp;: Nous allons donc utiliser les tables cr\u00e9\u00e9es dans l\u2019article \u00a0pr\u00e9c\u00e9dent:","_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1101"}],"version-history":[{"count":4,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1101\/revisions"}],"predecessor-version":[{"id":1105,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1101\/revisions\/1105"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}