{"id":931,"date":"2023-06-08T12:11:11","date_gmt":"2023-06-08T12:11:11","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=931"},"modified":"2023-06-08T12:12:30","modified_gmt":"2023-06-08T12:12:30","slug":"cross-join","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/cross-join\/","title":{"rendered":"CROSS JOIN"},"content":{"rendered":"\n<p>K\u00f5ikide v\u00f5imalike kombinatsioonide v\u00e4ljatr\u00fckiks sobib CROSS JOIN. Sel juhul v\u00f5tmeid tabelite \u00fchendamiseks ei kasutata, vaid tr\u00fckitakse v\u00e4lja k\u00f5ik v\u00f5imalikud kombinatsioonid, kuidas esimese tabeli read saavad olla \u00fchendatud teise tabeli ridadega. Ehk siis siin n\u00e4ites pakutakse v\u00e4lja k\u00f5ik kombinatsioonid, milline laps saab millise lemmikloomaga koos olla.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT nimi, loomanimi FROM lemmikloomad\nCROSS JOIN laps_tbl\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"408\" height=\"649\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-26.png\" alt=\"\" class=\"wp-image-936\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-26.png 408w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-26-189x300.png 189w\" sizes=\"auto, (max-width: 408px) 100vw, 408px\" \/><\/figure>\n\n\n\n<p>Eks sellist segapudru l\u00e4heb suhteliselt harvem vaja, aga ilus on vaadata, kes v\u00f5ib kellega koos olla. Samuti sobib CROSS JOIN olukordade jaoks, kui tahetakse k\u00f5ikide v\u00f5imalike variantide hulgast sobivat v\u00e4lja otsida. N\u00e4iteks soovitakse otsida kombinatsioonid, kus lapse ja looma nimed algavad sama t\u00e4hega, v\u00f5i siis on nad s\u00fcndinud samas kuus. Siinse n\u00e4ite puhul on tingimused pastakast v\u00e4lja imetud, aga m\u00f5ne tutvumis\u00f5htu puhul v\u00f5i laborikatsete juures v\u00f5ivad sellised valikud t\u00e4iesti omal kohal olla.<\/p>\n\n\n\n<p>CROSS JOINiga sama tulemuse annab, kui p\u00e4ringusse kirjutada lihtsalt tabelite nimed ilma t\u00e4iendavaid tingimusi seadmata.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT nimi, loomanimi FROM lemmikloomad, laps_tbl\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"611\" src=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-27.png\" alt=\"\" class=\"wp-image-939\" srcset=\"https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-27.png 407w, https:\/\/tarkvara.thkit.ee\/veeb\/wp-content\/uploads\/2023\/06\/image-27-200x300.png 200w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>K\u00f5ikide v\u00f5imalike kombinatsioonide v\u00e4ljatr\u00fckiks sobib CROSS JOIN. Sel juhul v\u00f5tmeid tabelite \u00fchendamiseks ei kasutata, vaid tr\u00fckitakse v\u00e4lja k\u00f5ik v\u00f5imalikud kombinatsioonid, kuidas esimese tabeli read saavad olla \u00fchendatud teise tabeli ridadega. Ehk siis siin n\u00e4ites pakutakse v\u00e4lja k\u00f5ik kombinatsioonid, milline laps saab millise lemmikloomaga koos olla. Eks sellist segapudru l\u00e4heb suhteliselt harvem vaja, aga ilus on &hellip; <a href=\"https:\/\/tarkvara.thkit.ee\/veeb\/cross-join\/\" class=\"more-link\">Loe edasi <span class=\"screen-reader-text\">CROSS 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-931","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/931","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=931"}],"version-history":[{"count":6,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/931\/revisions"}],"predecessor-version":[{"id":940,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/931\/revisions\/940"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}