{"id":918,"date":"2023-06-08T12:09:04","date_gmt":"2023-06-08T12:09:04","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=918"},"modified":"2023-06-08T12:10:48","modified_gmt":"2023-06-08T12:10:48","slug":"left-ja-right-join","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/left-ja-right-join\/","title":{"rendered":"LEFT ja RIGHT JOIN"},"content":{"rendered":"\n<p>K\u00f5ige tavalisema \u00fchendamise puhul saime kahest tabelist k\u00e4tte need read, mis m\u00f5lemas olemas olid. Ehk siis loetelus olid vaid lemmikloomaga lapsed ning samuti igas loetelus olnud lemmikloomal oli k\u00f5rval peremees. Et praeguses n\u00e4ites ei lubata peremeheta lemmikloomi tabelisse lisada, siis j\u00e4\u00e4b \u00e4ra ka v\u00f5imalus \u00fclej\u00e4\u00e4nud lemmikloomade n\u00e4itamiseks. K\u00fcll aga v\u00f5ib m\u00f5nikord olla soov n\u00e4ha ka neid lapsi, kel pole oma koera v\u00f5i kassi. Ning samas loomaomanikele panna k\u00f5rvale ka loomade andmed. Sellise t\u00f6\u00f6ga saab hakkama LEFT JOIN. Loetelus esimesena olnud tabelist ehk vasakust n\u00e4idatakse v\u00e4lja k\u00f5ik read. Paremast aga vaid need, kus seos vasaku tabeliga olemas. Kel looma pole, sel tuleb loomanime kohale t\u00fchiv\u00e4\u00e4rtus NULL.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT nimi, loomanimi FROM laps_tbl\nLEFT JOIN lemmikloomad \nON lemmikloomad.peremehe_id=laps.id\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"363\" height=\"493\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-22.png\" alt=\"\" class=\"wp-image-919\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-22.png 363w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-22-221x300.png 221w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/figure>\n\n\n\n<p>Sarnaselt t\u00f6\u00f6tab RIGHT JOIN. Ainult selle vahega, et n\u00e4idatakse v\u00e4lja k\u00f5ik parempoolses tabelis olevad andmed. Kui m\u00f5nele reale ei vasta kirjet vasakpoolses tabelis, siis n\u00e4idatakse selle koha peal vasakpoolse tabeli v\u00e4ljade kohal NULL. Et siin aga on igal loomal peremees, siis t\u00fchiv\u00e4\u00e4rtusi ei teki.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT eesnimi, loomanimi FROM lapsed\nRIGHT JOIN lemmikloomad \nON lemmikloomad.peremehe_id=lapsed.id\nSiiri   Miisu\nSiim    Pauka\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"378\" height=\"426\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-23.png\" alt=\"\" class=\"wp-image-922\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-23.png 378w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-23-266x300.png 266w\" sizes=\"auto, (max-width: 378px) 100vw, 378px\" \/><\/figure>\n\n\n\n<p>LEFT JOINi ja RIGHT JOINi pikem kuju on LEFT OUTER JOIN ning RIGHT OUTER JOIN. Aga nagu n\u00e4ha, tulemus j\u00e4\u00e4b samaks.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT nimi, loomanimi FROM laps_tbl\nRIGHT OUTER JOIN lemmikloomad \nON lemmikloomad.peremehe_id=laps.id\nSiiri   Miisu\nSiim    Pauka\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"324\" height=\"429\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-24.png\" alt=\"\" class=\"wp-image-924\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-24.png 324w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-24-227x300.png 227w\" sizes=\"auto, (max-width: 324px) 100vw, 324px\" \/><\/figure>\n\n\n\n<p>Nende \u00fchendamiste puhul peab kindlasti silmas pidama tabelite j\u00e4rjekorda. Kui panna lemmikloomad vasakuks tabeliks ja lapsed parempoolseks tabeliks ning \u00fchendamisel kasutada RIGHT JOINi ning tulbad nime j\u00e4rgi v\u00e4lja kutsuda, siis on tulemus sama, kui oleks kasutanud tabeleid teises j\u00e4rjekorras ning \u00fchendamiseks LEFT JOINi.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nSELECT nimi, loomanimi FROM lemmikloomad\nRIGHT JOIN laps_tbl \nON lemmikloomad.peremehe_id=laps.id\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"350\" height=\"484\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-25.png\" alt=\"\" class=\"wp-image-928\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-25.png 350w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-25-217x300.png 217w\" sizes=\"auto, (max-width: 350px) 100vw, 350px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>K\u00f5ige tavalisema \u00fchendamise puhul saime kahest tabelist k\u00e4tte need read, mis m\u00f5lemas olemas olid. Ehk siis loetelus olid vaid lemmikloomaga lapsed ning samuti igas loetelus olnud lemmikloomal oli k\u00f5rval peremees. Et praeguses n\u00e4ites ei lubata peremeheta lemmikloomi tabelisse lisada, siis j\u00e4\u00e4b \u00e4ra ka v\u00f5imalus \u00fclej\u00e4\u00e4nud lemmikloomade n\u00e4itamiseks. K\u00fcll aga v\u00f5ib m\u00f5nikord olla soov n\u00e4ha ka &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/left-ja-right-join\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">LEFT ja RIGHT JOIN<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-918","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=918"}],"version-history":[{"count":7,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/918\/revisions"}],"predecessor-version":[{"id":930,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/918\/revisions\/930"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}