{"id":446,"date":"2025-04-11T11:39:23","date_gmt":"2025-04-11T08:39:23","guid":{"rendered":"https:\/\/com17699.wordpress.com\/?page_id=446"},"modified":"2025-04-11T11:39:23","modified_gmt":"2025-04-11T08:39:23","slug":"join","status":"publish","type":"page","link":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/","title":{"rendered":"Seosed"},"content":{"rendered":"\n<pre class=\"wp-block-syntaxhighlighter-code\">select*from Employees\nselect * from Department<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"340\" height=\"349\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png?w=340\" alt=\"\" class=\"wp-image-447\" srcset=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png 340w, https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8-292x300.png 292w\" sizes=\"auto, (max-width: 340px) 100vw, 340px\" \/><\/figure>\n\n\n\n<p>Seosed &#8211; join<br>f\u00fc\u00fcsiline seos &#8211; on lisatud Foreigenkey (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammi<br>loogolone seos &#8211; kui \u00f5igesti kirjutada select joiniga<\/p>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--JOIN\nSelect * from Employees join Department\non Employees.DepartmentId=Department.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"588\" height=\"184\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-9.png?w=588\" alt=\"\" class=\"wp-image-448\" srcset=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-9.png 588w, https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-9-300x94.png 300w\" sizes=\"auto, (max-width: 588px) 100vw, 588px\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--kirjutamine lihtsamaks\nSelect e.Name, e.Salary, d.DepartmentName\nfrom Employees e join Department d \non e.DepartmentId=d.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"235\" height=\"178\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-10.png?w=235\" alt=\"\" class=\"wp-image-449\" \/><\/figure>\n\n\n\n<p>inner join sama nagu lihtne join<br>n\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus<\/p>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">Select e.Name, e.Salary, d.DepartmentName\nfrom Employees e Inner join Department d \non e.DepartmentId=d.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"255\" height=\"195\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-11.png?w=255\" alt=\"\" class=\"wp-image-450\" \/><\/figure>\n\n\n\n<p>left Join<br>n\u00e4itab k\u00f5ike DepartmentName (Null v\u00e4\u00e4rtused)<\/p>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">Select e.Name, e.Salary, d.DepartmentName\nfrom Employees e left join Department d \non e.DepartmentId=d.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"239\" height=\"220\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-12.png?w=239\" alt=\"\" class=\"wp-image-451\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--right Join\nSelect e.Name, e.Salary, d.DepartmentName\nfrom Employees e right join Department d \non e.DepartmentId=d.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"288\" height=\"259\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-13.png?w=288\" alt=\"\" class=\"wp-image-452\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--outer join = full outer 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<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-14.png?w=238\" alt=\"\" class=\"wp-image-453\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--cross join\n--n\u00e4itab nii, et 1.tabelis v\u00e4\u00e4rtused * 2.tabeli v\u00e4\u00e4rtused\nselect Name, Salary, DepartmentName\nfrom Employees cross join Department<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-15.png?w=234\" alt=\"\" class=\"wp-image-454\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--N\u00e4idata ainult need isikud, kellel departmentName on Null\nSelect e.Name, e.Salary, d.DepartmentName\nfrom Employees e right join Department d \non e.DepartmentId=d.Id\nwhere d.DepartmentName is Null;<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-16.png?w=259\" alt=\"\" class=\"wp-image-455\" style=\"width:319px;height:auto\" \/><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<p>teha k\u00f5ik join&#8217;id<br>ja kirjutadamida nad n\u00e4itavad<\/p>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--JOIN\nSelect * from Employees join Manager\non Employees.managerId=Manager.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-17.png?w=481\" alt=\"\" class=\"wp-image-456\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--kirjutamine lihtsamaks\nSelect e.Name, e.Salary, m.managerName\nfrom Employees e join Manager m \non e.ManagerID=m.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-18.png?w=220\" alt=\"\" class=\"wp-image-457\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--inner join sama nagu lihtne 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<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-19.png?w=225\" alt=\"\" class=\"wp-image-458\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--left Join\n--n\u00e4itab k\u00f5ike ManagerName (Null v\u00e4\u00e4rtused) \nSelect e.Name, e.Salary, m.managerName\nfrom Employees e left join Manager m \non e.ManagerID=m.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-20.png?w=231\" alt=\"\" class=\"wp-image-459\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--right Join\nSelect e.Name, e.Salary, m.managerName\nfrom Employees e right join Manager m \non e.ManagerID=m.Id<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-21.png?w=231\" alt=\"\" class=\"wp-image-460\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--outer join = full 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<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-22.png?w=234\" alt=\"\" class=\"wp-image-461\" \/><\/figure>\n\n\n\n<pre class=\"wp-block-syntaxhighlighter-code\">--cross join\n--n\u00e4itab nii, et 1.tabelis v\u00e4\u00e4rtused * 2.tabeli v\u00e4\u00e4rtused\nselect Name, Salary, managerName\nfrom Employees cross join Manager<\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-23.png?w=219\" alt=\"\" class=\"wp-image-462\" \/><\/figure>\n\n\n\n<!--nextpage-->\n\n\n\n<h2 class=\"wp-block-heading\">Harjutust<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-24.png?w=695\" alt=\"\" class=\"wp-image-463\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-25.png?w=797\" alt=\"\" class=\"wp-image-464\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-26.png?w=634\" alt=\"\" class=\"wp-image-465\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreigenkey (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammiloogolone seos &#8211; kui \u00f5igesti kirjutada select joiniga inner join sama nagu lihtne joinn\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus left Joinn\u00e4itab k\u00f5ike DepartmentName (Null v\u00e4\u00e4rtused)<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"%d0%b2%d0%bb%d0%b0%d1%81%d0%bd%d0%b8%d0%b8-%d1%88%d0%b0%d0%b1%d0%bb%d0%be%d0%bd-3","meta":{"_uag_custom_page_level_css":"","footnotes":""},"class_list":["post-446","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 - Portfoolio Mariia Posvystak<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/\" \/>\n<link rel=\"next\" href=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/2\/\" \/>\n<meta property=\"og:locale\" content=\"et_EE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seosed - Portfoolio Mariia Posvystak\" \/>\n<meta property=\"og:description\" content=\"Seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreigenkey (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammiloogolone seos &#8211; kui \u00f5igesti kirjutada select joiniga inner join sama nagu lihtne joinn\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus left Joinn\u00e4itab k\u00f5ike DepartmentName (Null v\u00e4\u00e4rtused)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/\" \/>\n<meta property=\"og:site_name\" content=\"Portfoolio Mariia Posvystak\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png\" \/>\n\t<meta property=\"og:image:width\" content=\"340\" \/>\n\t<meta property=\"og:image:height\" content=\"349\" \/>\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=\"2 minutit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/\",\"url\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/\",\"name\":\"Seosed - Portfoolio Mariia Posvystak\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-8.png?w=340\",\"datePublished\":\"2025-04-11T08:39:23+00:00\",\"inLanguage\":\"et\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/join\\\/#primaryimage\",\"url\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-8.png\",\"contentUrl\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-8.png\",\"width\":340,\"height\":349},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/#website\",\"url\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/\",\"name\":\"Portfoolio Mariia Posvystak\",\"description\":\"Noorem tarkvaraarendaja\",\"publisher\":{\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/9927ec37846ce78ee14ecf928e2e711f\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"et\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/#\\\/schema\\\/person\\\/9927ec37846ce78ee14ecf928e2e711f\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"et\",\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-icon.jpg\",\"url\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-icon.jpg\",\"contentUrl\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-icon.jpg\",\"width\":512,\"height\":512,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/cropped-icon.jpg\"},\"sameAs\":[\"https:\\\/\\\/mariiaposvystak24.thkit.ee\\\/wp\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Seosed - Portfoolio Mariia Posvystak","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:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/","next":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/2\/","og_locale":"et_EE","og_type":"article","og_title":"Seosed - Portfoolio Mariia Posvystak","og_description":"Seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreigenkey (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammiloogolone seos &#8211; kui \u00f5igesti kirjutada select joiniga inner join sama nagu lihtne joinn\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus left Joinn\u00e4itab k\u00f5ike DepartmentName (Null v\u00e4\u00e4rtused)","og_url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/","og_site_name":"Portfoolio Mariia Posvystak","og_image":[{"width":340,"height":349,"url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/","url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/","name":"Seosed - Portfoolio Mariia Posvystak","isPartOf":{"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/#primaryimage"},"image":{"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/#primaryimage"},"thumbnailUrl":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png?w=340","datePublished":"2025-04-11T08:39:23+00:00","inLanguage":"et","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/"]}]},{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/join\/#primaryimage","url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png","contentUrl":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/04\/pilt-8.png","width":340,"height":349},{"@type":"WebSite","@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/#website","url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/","name":"Portfoolio Mariia Posvystak","description":"Noorem tarkvaraarendaja","publisher":{"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/#\/schema\/person\/9927ec37846ce78ee14ecf928e2e711f"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"et"},{"@type":["Person","Organization"],"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/#\/schema\/person\/9927ec37846ce78ee14ecf928e2e711f","name":"admin","image":{"@type":"ImageObject","inLanguage":"et","@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/11\/cropped-icon.jpg","url":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/11\/cropped-icon.jpg","contentUrl":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/11\/cropped-icon.jpg","width":512,"height":512,"caption":"admin"},"logo":{"@id":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-content\/uploads\/2025\/11\/cropped-icon.jpg"},"sameAs":["https:\/\/mariiaposvystak24.thkit.ee\/wp"]}]}},"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"dictionary-thumbnail":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/blog\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"Seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreigenkey (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammiloogolone seos &#8211; kui \u00f5igesti kirjutada select joiniga inner join sama nagu lihtne joinn\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus left Joinn\u00e4itab k\u00f5ike DepartmentName (Null v\u00e4\u00e4rtused)","_links":{"self":[{"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/446","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/comments?post=446"}],"version-history":[{"count":0,"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/pages\/446\/revisions"}],"wp:attachment":[{"href":"https:\/\/mariiaposvystak24.thkit.ee\/wp\/wp-json\/wp\/v2\/media?parent=446"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}