{"id":737,"date":"2025-04-11T10:44:17","date_gmt":"2025-04-11T07:44:17","guid":{"rendered":"https:\/\/lnikita0.wordpress.com\/?page_id=737"},"modified":"2025-04-11T10:44:17","modified_gmt":"2025-04-11T07:44:17","slug":"sql-seosed","status":"publish","type":"page","link":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/","title":{"rendered":"SQL Seosed"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>seosed <\/strong>&#8211; join<br><strong>f\u00fc\u00fcsiline seos <\/strong>&#8211; on lisatud Foreign key (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammil)<br><strong>loogiline seos <\/strong>&#8211; kui \u00f5igesti kirjutatada select joiniga<\/p>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-9.png?w=597\" alt=\"\" class=\"wp-image-738\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-10.png?w=600\" alt=\"\" class=\"wp-image-740\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>INNER JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-11.png?w=619\" alt=\"\" class=\"wp-image-741\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>LEFT JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-13.png?w=627\" alt=\"\" class=\"wp-image-744\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>RIGHT JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-15.png?w=600\" alt=\"\" class=\"wp-image-748\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>OUTER JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-16.png?w=644\" alt=\"\" class=\"wp-image-750\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>CROSS JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-18.png?w=766\" alt=\"\" class=\"wp-image-754\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong><em>Manager ja Employees<\/em><\/strong><br><strong>(INNER) JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-21.png?w=649\" alt=\"\" class=\"wp-image-761\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>LEFT JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-22.png?w=594\" alt=\"\" class=\"wp-image-762\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>RIGHT JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-23.png?w=576\" alt=\"\" class=\"wp-image-765\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>FULL OUTER JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-24.png?w=618\" alt=\"\" class=\"wp-image-766\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>CROSS JOIN<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-26.png?w=800\" alt=\"\" class=\"wp-image-769\" \/><\/figure>\n\n\n\n<p class=\"has-light-green-cyan-background-color has-background has-large-font-size wp-block-paragraph\"><strong>K\u00dcSIMUSED<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-27.png?w=1013\" alt=\"\" class=\"wp-image-771\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-28.png?w=1024\" alt=\"\" class=\"wp-image-773\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-29.png?w=1024\" alt=\"\" class=\"wp-image-775\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>4.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-30.png?w=1023\" alt=\"\" class=\"wp-image-777\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>5.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-31.png?w=1024\" alt=\"\" class=\"wp-image-779\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammil)loogiline seos &#8211; kui \u00f5igesti kirjutatada select joiniga JOIN INNER JOIN LEFT JOIN RIGHT JOIN OUTER JOIN CROSS JOIN Manager ja Employees(INNER) JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN K\u00dcSIMUSED 1. 2. 3. 4. 5.<\/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-737","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Seosed - Nikita Litvinenko Portfolio<\/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:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Seosed - Nikita Litvinenko Portfolio\" \/>\n<meta property=\"og:description\" content=\"seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammil)loogiline seos &#8211; kui \u00f5igesti kirjutatada select joiniga JOIN INNER JOIN LEFT JOIN RIGHT JOIN OUTER JOIN CROSS JOIN Manager ja Employees(INNER) JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN K\u00dcSIMUSED 1. 2. 3. 4. 5.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/\" \/>\n<meta property=\"og:site_name\" content=\"Nikita Litvinenko Portfolio\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/\",\"name\":\"SQL Seosed - Nikita Litvinenko Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/lnikita0.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-9.png?w=597\",\"datePublished\":\"2025-04-11T07:44:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/#primaryimage\",\"url\":\"https:\\\/\\\/lnikita0.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-9.png?w=597\",\"contentUrl\":\"https:\\\/\\\/lnikita0.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/image-9.png?w=597\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/sql-seosed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Seosed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Nikita Litvinenko Portfolio\",\"description\":\"Junior Software Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nikitalitvinenko24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Seosed - Nikita Litvinenko Portfolio","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:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/","og_locale":"en_GB","og_type":"article","og_title":"SQL Seosed - Nikita Litvinenko Portfolio","og_description":"seosed &#8211; joinf\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammil)loogiline seos &#8211; kui \u00f5igesti kirjutatada select joiniga JOIN INNER JOIN LEFT JOIN RIGHT JOIN OUTER JOIN CROSS JOIN Manager ja Employees(INNER) JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN K\u00dcSIMUSED 1. 2. 3. 4. 5.","og_url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/","og_site_name":"Nikita Litvinenko Portfolio","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/","name":"SQL Seosed - Nikita Litvinenko Portfolio","isPartOf":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/#primaryimage"},"image":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/#primaryimage"},"thumbnailUrl":"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-9.png?w=597","datePublished":"2025-04-11T07:44:17+00:00","breadcrumb":{"@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/#primaryimage","url":"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-9.png?w=597","contentUrl":"https:\/\/lnikita0.wordpress.com\/wp-content\/uploads\/2025\/04\/image-9.png?w=597"},{"@type":"BreadcrumbList","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/sql-seosed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"SQL Seosed"}]},{"@type":"WebSite","@id":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/","name":"Nikita Litvinenko Portfolio","description":"Junior Software Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"_links":{"self":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/737","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=737"}],"version-history":[{"count":0,"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/737\/revisions"}],"wp:attachment":[{"href":"https:\/\/nikitalitvinenko24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=737"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}