{"id":689,"date":"2025-04-11T10:44:31","date_gmt":"2025-04-11T07:44:31","guid":{"rendered":"https:\/\/artjompoldsaar1.wordpress.com\/?page_id=689"},"modified":"2025-04-11T10:44:31","modified_gmt":"2025-04-11T07:44:31","slug":"seosed","status":"publish","type":"page","link":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/","title":{"rendered":"Seosed"},"content":{"rendered":"\n<p>Joins<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>F\u00fc\u00fcsiline seos &#8211; on lisatud Foreign key (constraint &#8211; piirang n\u00e4iteks kontrollida diagrammil)<\/li>\n\n\n\n<li>Loogiline seos &#8211; kui \u00f5igesti kirjutada select joiniga<\/li>\n<\/ul>\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--n\u00e4itab k\u00f5ik department, kus on olemas v\u00e4\u00e4rtus\nselect * from Employees join Department\non Employees.DepartmentId = Department.Id;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-5.png?w=584\" alt=\"\" class=\"wp-image-692\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">INNER JOIN<\/h2>\n\n\n\n<p>Sama asi nagu JOIN.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--n\u00e4itab k\u00f5ik department, 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:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-6.png?w=270\" alt=\"\" class=\"wp-image-695\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">LEFT JOIN<\/h2>\n\n\n\n<p>\u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0442\u0430\u043a\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 <strong>\u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u043b\u0435\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/strong> (\u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 Country), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--n\u00e4itab k\u00f5ike departmentName (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:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-7.png?w=265\" alt=\"\" class=\"wp-image-697\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">RIGHT JOIN<\/h2>\n\n\n\n<p>\u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0438\u0437 \u043f\u0440\u0430\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (City), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--n\u00e4itab k\u00f5ike department, isegi kui nad ei ole kasutatud\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 decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-8.png?w=269\" alt=\"\" class=\"wp-image-700\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">FULL OUTER JOIN<\/h2>\n\n\n\n<p>Kuvab k\u00f5ik seosed, LEFT, JOIN, INNER<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--outer join = outer full join\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 decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-9.png?w=242\" alt=\"\" class=\"wp-image-703\" \/><\/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: plain; title: ; notranslate\" title=\"\">\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<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-10.png?w=246\" alt=\"\" class=\"wp-image-707\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">N\u00e4ided<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--N\u00e4idata ainult need isikud, kellel departmentName on null\nselect e.Name, e.Salary, d.DepartmentName \nfrom Employees e left join Department d\non e.DepartmentId = d.Id\nwhere d.DepartmentName is null;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-11.png?w=273\" alt=\"\" class=\"wp-image-709\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"ulesanne\">\u00dclesanne<\/h2>\n\n\n\n<p>Teha k\u00f5ik joinid, ja kirjutada mid nad n\u00e4itavad kasutadeks uut tabelit Manager<\/p>\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--n\u00e4ita k\u00f5ik employees kelle Manager on v\u00e4\u00e4rtusega\nselect e.Name, e.Salary, m.ManagerName\nfrom Employees e inner 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:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-12.png?w=255\" alt=\"\" class=\"wp-image-713\" \/><\/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 employees, isegi kui Manager on null\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 decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-13.png?w=236\" alt=\"\" class=\"wp-image-714\" \/><\/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\u00e4ita k\u00f5ik employees ja nende Manager, kellel on v\u00e4\u00e4rtus, ja n\u00e4ita k\u00f5ik Manager kellel ei ole Employees\nselect e.Name, e.Salary, m.ManagerName\nfrom Employees e right 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:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-14.png?w=242\" alt=\"\" class=\"wp-image-715\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">FULL OUTER JOIN<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n--full outer join\n--n\u00e4ita k\u00f5ik seosed left, right, inner\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:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-15.png?w=233\" alt=\"\" class=\"wp-image-716\" \/><\/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--Employees * Manager\nselect Name, Salary, ManagerName\nfrom Employees cross join Manager;\n<\/pre><\/div>\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-16.png?w=250\" alt=\"\" class=\"wp-image-717\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Testid<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-17.png?w=816\" alt=\"\" class=\"wp-image-721\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-18.png?w=338\" alt=\"\" class=\"wp-image-722\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-19.png?w=761\" alt=\"\" class=\"wp-image-724\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-20.png?w=503\" alt=\"\" class=\"wp-image-726\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-21.png?w=555\" alt=\"\" class=\"wp-image-727\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Joins JOIN INNER JOIN Sama asi nagu JOIN. LEFT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0442\u0430\u043a\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u043b\u0435\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (\u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 Country), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. RIGHT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0438\u0437 \u043f\u0440\u0430\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (City), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. FULL OUTER JOIN Kuvab k\u00f5ik seosed, LEFT, JOIN, INNER CROSS JOIN N\u00e4ided \u00dclesanne Teha k\u00f5ik joinid, ja kirjutada mid nad n\u00e4itavad kasutadeks uut tabelit Manager INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN Testid<\/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-689","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 - Artjom P\u00f5ldsaar 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:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Seosed - Artjom P\u00f5ldsaar Portfolio\" \/>\n<meta property=\"og:description\" content=\"Joins JOIN INNER JOIN Sama asi nagu JOIN. LEFT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0442\u0430\u043a\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u043b\u0435\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (\u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 Country), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. RIGHT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0438\u0437 \u043f\u0440\u0430\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (City), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. FULL OUTER JOIN Kuvab k\u00f5ik seosed, LEFT, JOIN, INNER CROSS JOIN N\u00e4ided \u00dclesanne Teha k\u00f5ik joinid, ja kirjutada mid nad n\u00e4itavad kasutadeks uut tabelit Manager INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN Testid\" \/>\n<meta property=\"og:url\" content=\"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/\" \/>\n<meta property=\"og:site_name\" content=\"Artjom P\u00f5ldsaar Portfolio\" \/>\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 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/\",\"url\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/\",\"name\":\"Seosed - Artjom P\u00f5ldsaar Portfolio\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/artjompoldsaar1.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-5.png?w=584\",\"datePublished\":\"2025-04-11T07:44:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/#primaryimage\",\"url\":\"https:\\\/\\\/artjompoldsaar1.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-5.png?w=584\",\"contentUrl\":\"https:\\\/\\\/artjompoldsaar1.wordpress.com\\\/wp-content\\\/uploads\\\/2025\\\/04\\\/pilt-5.png?w=584\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/seosed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Seosed\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/#website\",\"url\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/\",\"name\":\"Artjom P\u00f5ldsaar Portfolio\",\"description\":\"Junior Software Developer\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/artjompoldsaar24.thkit.ee\\\/wp\\\/eng\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Seosed - Artjom P\u00f5ldsaar 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:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/","og_locale":"en_US","og_type":"article","og_title":"Seosed - Artjom P\u00f5ldsaar Portfolio","og_description":"Joins JOIN INNER JOIN Sama asi nagu JOIN. LEFT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0442\u0430\u043a\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u043b\u0435\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (\u0432 \u0434\u0430\u043d\u043d\u043e\u043c \u0441\u043b\u0443\u0447\u0430\u0435 Country), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 City \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. RIGHT JOIN \u0412 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u0435 \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u043f\u0440\u0438\u0441\u0443\u0442\u0441\u0442\u0432\u0443\u044e\u0442 \u0432\u0441\u0435 \u0437\u0430\u043f\u0438\u0441\u0438 \u0438\u0437 \u043f\u0440\u0430\u0432\u043e\u0439 \u0442\u0430\u0431\u043b\u0438\u0446\u044b (City), \u043d\u0435\u0441\u043c\u043e\u0442\u0440\u044f \u043d\u0430 \u0442\u043e \u0435\u0441\u0442\u044c \u043b\u0438 \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0443\u044e\u0449\u0438\u0435 \u043f\u043e join \u0443\u0441\u043b\u043e\u0432\u0438\u044e \u0437\u0430\u043f\u0438\u0441\u0438 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country. \u0417\u043d\u0430\u0447\u0435\u043d\u0438\u044f, \u0441\u043e\u043e\u0442\u0432\u0435\u0442\u0441\u0442\u0432\u0438\u0435 \u043a\u043e\u0442\u043e\u0440\u044b\u043c \u043d\u0435\u0442 \u0432 \u0442\u0430\u0431\u043b\u0438\u0446\u0435 Country \u0437\u0430\u043c\u0435\u043d\u044f\u044e\u0442\u0441\u044f \u0432 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c NULL. FULL OUTER JOIN Kuvab k\u00f5ik seosed, LEFT, JOIN, INNER CROSS JOIN N\u00e4ided \u00dclesanne Teha k\u00f5ik joinid, ja kirjutada mid nad n\u00e4itavad kasutadeks uut tabelit Manager INNER JOIN LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN Testid","og_url":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/","og_site_name":"Artjom P\u00f5ldsaar Portfolio","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/","url":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/","name":"Seosed - Artjom P\u00f5ldsaar Portfolio","isPartOf":{"@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/#website"},"primaryImageOfPage":{"@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/#primaryimage"},"image":{"@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/#primaryimage"},"thumbnailUrl":"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-5.png?w=584","datePublished":"2025-04-11T07:44:31+00:00","breadcrumb":{"@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/#primaryimage","url":"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-5.png?w=584","contentUrl":"https:\/\/artjompoldsaar1.wordpress.com\/wp-content\/uploads\/2025\/04\/pilt-5.png?w=584"},{"@type":"BreadcrumbList","@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/seosed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/"},{"@type":"ListItem","position":2,"name":"Seosed"}]},{"@type":"WebSite","@id":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/#website","url":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/","name":"Artjom P\u00f5ldsaar Portfolio","description":"Junior Software Developer","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":0,"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/pages\/689\/revisions"}],"wp:attachment":[{"href":"https:\/\/artjompoldsaar24.thkit.ee\/wp\/eng\/wp-json\/wp\/v2\/media?parent=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}