{"id":1285,"date":"2025-04-11T11:00:08","date_gmt":"2025-04-11T08:00:08","guid":{"rendered":"https:\/\/com47276.wordpress.com\/?page_id=702"},"modified":"2025-11-13T13:00:34","modified_gmt":"2025-11-13T13:00:34","slug":"seosed-2","status":"publish","type":"page","link":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/","title":{"rendered":"Seosed"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Seosed<\/h2>\n\n\n\n<p><a href=\"https:\/\/metshein.com\/courses\/andmebaaside-alused\/lessons\/sql-server-skalaarfunktsioonid-ja-seosed\/\">&#8212; seosed &#8211; join<\/a><br>&#8211;f\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constreint &#8211; piirang n\u00e4iteks kontrollida diagrammi)<br>&#8211;loogiline seos &#8211; kui \u00f5igest kirjutada select joiniga<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--Join\nselect * from Employees join Department\non Employees.DepartmentId=Department.Id;\n--kirjutame lihtsamaks\nselect e.Name, e.Salary, d.DepartmentName \nfrom Employees e join Department d\non e.DepartmentId=d.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"218\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png?w=573\" alt=\"\" class=\"wp-image-689\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png 573w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13-300x114.png 300w\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Inner join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--inner join sama nagu lihtne join\n-- n\u00e4itab k\u00f5ik deprtment_ kus on olemas v\u00e4\u00e4rtus\nselect e.Name, e.Salary, d.DepartmentName \nfrom Employees e inner join Department d\non e.DepartmentId=d.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-14-1.png?w=227\" alt=\"\" class=\"wp-image-690\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">left join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--left join\n--n\u00e4ita k\u00f5ik Department Name (NULL v\u00e4\u00e4rtused)\nselect e.Name, e.Salary, d.DepartmentName \nfrom Employees e left join Department d\non e.DepartmentId=d.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-15.png?w=232\" alt=\"\" class=\"wp-image-692\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Right join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--right join\n--n\u00e4itab departmentName, kus Name on null (NULL v\u00e4\u00e4rtused)\n-- RUGHT JOIN = RIGHT OUTHER JOIN\nselect e.Name,e.Salary, d.DepartmentName \nfrom Employees e right join Department d\non e.DepartmentId=d.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"233\" height=\"245\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-16.png?w=233\" alt=\"\" class=\"wp-image-695\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Outer Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--outer join = full othr join\n--n\u00e4itab k\u00f5ik v\u00e4\u00e4rtused kahest tabelist\nselect e.Name,e.Salary, d.DepartmentName \nfrom Employees e full outer join Department d\non e.DepartmentId=d.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"272\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-17.png?w=235\" alt=\"\" class=\"wp-image-697\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Cross Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--cross join\n--n\u00e4itab nii_ et 1.tabeli v\u00e4\u00e4rtused * 2. tabeli v\u00e4\u00e4rtused\nselect Name,Salary, DepartmentName \nfrom Employees cross join Department \n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"228\" height=\"390\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-18.png?w=228\" alt=\"\" class=\"wp-image-699\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-18.png 228w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-18-175x300.png 175w\" sizes=\"auto, (max-width: 228px) 100vw, 228px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Manager inner join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--inner join\n-- n\u00e4itab k\u00f5ik manager, kus on olemas v\u00e4\u00e4rtus\nselect e.Name,e.Salary, m.managerName\nfrom Employees e inner join Manager m\non e.managerID=m.id;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"214\" height=\"264\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-21.png?w=214\" alt=\"\" class=\"wp-image-709\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Manager Left join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--left join\n--n\u00e4itab k\u00f5ik managerName (NULL v\u00e4\u00e4rtused)\nselect e.Name,e.Salary, m.managerName\nfrom Employees e left join Manager m\non e.managerID=m.id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"212\" height=\"285\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-20.png?w=212\" alt=\"\" class=\"wp-image-707\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Manager Right Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--right join\n--n\u00e4itab managerName, kus Name on null (NULL v\u00e4\u00e4rtused)\nselect e.Name,e.Salary, m.managerName\nfrom Employees e right join Manager m\non e.managerID=m.id;\n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-22-1.png?w=215\" alt=\"\" class=\"wp-image-711\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Manager Outer Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--outer join\n--n\u00e4itab k\u00f5ik v\u00e4\u00e4rtused kahest tabelist\nselect e.Name,e.Salary, m.managerName\nfrom Employees e full outer join Manager m\non e.managerID=m.id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-23-1.png?w=218\" alt=\"\" class=\"wp-image-713\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Manager Cross Join<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--cross join\n--n\u00e4itab nii_ et 1.tabeli v\u00e4\u00e4rtused * 2. tabeli v\u00e4\u00e4rtused\nselect Name,Salary,managerName\nfrom Employees cross join Manager \n\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"219\" height=\"391\" src=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-24.png?w=219\" alt=\"\" class=\"wp-image-715\" srcset=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-24.png 219w, https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-24-168x300.png 168w\" sizes=\"auto, (max-width: 219px) 100vw, 219px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/andmebaas\/\">&#8212; Andmebaas &#8212;<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seosed &#8212; seosed &#8211; join&#8211;f\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constreint &#8211; piirang n\u00e4iteks kontrollida diagrammi)&#8211;loogiline seos &#8211; kui [&hellip;]<\/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-1285","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Seosed - Oleksandra Ryshniak Portfolio<\/title>\n<meta name=\"description\" content=\"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seosed - Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"og:description\" content=\"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Oleksandra Ryshniak Portfolio\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-13T13:00:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png\" \/>\n\t<meta property=\"og:image:width\" content=\"573\" \/>\n\t<meta property=\"og:image:height\" content=\"218\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/\",\"name\":\"Seosed - Oleksandra Ryshniak Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-13.png?w=573\",\"datePublished\":\"2025-04-11T08:00:08+00:00\",\"dateModified\":\"2025-11-13T13:00:34+00:00\",\"description\":\"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/#breadcrumb\"},\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-13.png\",\"contentUrl\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-13.png\",\"width\":573,\"height\":218},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/seosed-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Seosed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/#website\",\"url\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/\",\"name\":\"Oleksandra Ryshniak Portfolio\",\"description\":\"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oleksandraryshniak24.thkit.ee\\\/wp1\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Seosed - Oleksandra Ryshniak Portfolio","description":"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/","og_locale":"et_EE","og_type":"article","og_title":"Seosed - Oleksandra Ryshniak Portfolio","og_description":"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga","og_url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/","og_site_name":"Oleksandra Ryshniak Portfolio","article_modified_time":"2025-11-13T13:00:34+00:00","og_image":[{"width":573,"height":218,"url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/","name":"Seosed - Oleksandra Ryshniak Portfolio","isPartOf":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/#primaryimage"},"image":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/#primaryimage"},"thumbnailUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png?w=573","datePublished":"2025-04-11T08:00:08+00:00","dateModified":"2025-11-13T13:00:34+00:00","description":"Seosed - join. F\u00fc\u00fcsiline seos - on lisatud Foreign key. Loogiline seos - kui \u00f5igest kirjutada select joiniga","breadcrumb":{"@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/#breadcrumb"},"inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/#primaryimage","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png","contentUrl":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-content\/uploads\/2025\/04\/image-13.png","width":573,"height":218},{"@type":"BreadcrumbList","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/seosed-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/"},{"@type":"ListItem","position":2,"name":"Seosed"}]},{"@type":"WebSite","@id":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/#website","url":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/","name":"Oleksandra Ryshniak Portfolio","description":"\u041f\u0440\u043e\u0441\u0442\u043e \u0435\u0449\u0435 \u043e\u0434\u0438\u043d WordPress \u0441\u0430\u0439\u0442","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"}]}},"_links":{"self":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1285","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/comments?post=1285"}],"version-history":[{"count":2,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1285\/revisions"}],"predecessor-version":[{"id":1791,"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/pages\/1285\/revisions\/1791"}],"wp:attachment":[{"href":"https:\/\/oleksandraryshniak24.thkit.ee\/wp1\/wp-json\/wp\/v2\/media?parent=1285"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}