{"id":54818,"date":"2023-07-29T19:09:46","date_gmt":"2023-07-29T19:09:46","guid":{"rendered":"https:\/\/dbtut.com\/?p=54818"},"modified":"2023-07-29T19:11:16","modified_gmt":"2023-07-29T19:11:16","slug":"postgresql-inner-join","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/","title":{"rendered":"PostgreSQL Inner Join"},"content":{"rendered":"

In today’s article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.<\/p>\n

Join and Inner Join mean the same thing, we can get the same result by typing both ways.<\/p>\n

Before using Inner Join, we need to find common columns to join the tables.<\/p>\n

As seen in the picture below, the common intersection tables are the id and cityid columns, and we can combine them by equating them with each other.<\/p>\n

General usage;<\/h4>\n
SELECT*FROM  tablo_1 as takma_isim INNER JOIN  tablo_2 as takma_isim\r\n  ON takma_isim.tablo_1=takma_isim.tablo_2<\/pre>\n
<\/p>\n
Let’s create a database for the inner join below and insert data into it.<\/p>\n
CREATE DATABASE join_ornek;\r\nCREATE TABLE Sehirler(id int,SehirIsmi text);\r\nCREATE TABLE MeshurYiyecekler(id integer,Sehirid integer,YiyecekIsmi text);\r\nINSERT INTO Sehirler(id,SehirIsmi)VALUES(1,'Adana');\r\nINSERT INTO Sehirler(id,SehirIsmi)VALUES(42,'Konya');\r\nINSERT INTO Sehirler(id,SehirIsmi)VALUES(3,'Afyon');\r\nINSERT INTO MeshurYiyecekler(id,Sehirid,YiyecekIsmi)VALUES(1,1,'Kebap');\r\nINSERT INTO MeshurYiyecekler(id,Sehirid,YiyecekIsmi)VALUES(2,42,'Etli Ekmek');\r\nINSERT INTO MeshurYiyecekler(id,Sehirid,YiyecekIsmi)VALUES(3,3,'Kaymak');<\/pre>\n
We have created our Cities and MeshurYiyecekler tables, now let’s write the plgpsql sentence that will show which dishes are well prepared in which cities.<\/p>\n
SELECT s.sehirismi,my.yiyecekismi FROM sehirler as s INNER JOIN meshuryiyecekler as my ON s.id=my.sehirid;\r\n<\/pre>\n
<\/p>\n
In the example above, we combined the two tables and wrote the columns of these tables that we want to be seen between the words SELECT and FROM, and we saw which products are famous for which dishes.<\/p>\n
If we add a record to the Cities table and do not add the famous food of this city to the MeshurYiyecekler table, this record will not come up during the join process.<\/p>\n
For testing, let’s add a record to the Cities table, but not add the famous food of the relevant city to the MeshurYiyecekler table.<\/p>\n
<\/p>\n
SELECT s.sehirismi,my.yiyecekismi FROM sehirler as s INNER JOIN meshuryiyecekler as my ON s.id=my.sehirid;\r\n<\/pre>\n
<\/p>\n
As seen above, it does not appear despite adding the province of Gaziantep.<\/p>\n
This is because there is no equivalent in the MeshurYiyecekler table.<\/p>\n
As you can see, when we ran the INNER JOIN script that we just ran, there was no record of Gaziantep.<\/p>\n
The \u201cs\u201d at the end of the Cities table and the \u201cmy\u201d at the end of the MeshurYiyecekler table are called alias.<\/p>\n
In this way, you can write your scripts in a more understandable way.<\/p>\n
As you can see in the script below, if we have defined alias, we need to draw the columns we need by using alias in the select part.<\/p>\n
If there is a column with the same name in both tables and you write the name of the column in the select section without defining alias, you will get an error like the one below.<\/p>\n
select ID,SehirIsmi,YiyecekIsmi from Sehirler as  s INNER JOIN MeshurYiyecekler my ON s.ID=my.SehirID\r\n<\/pre>\n
When we query without using Alias like the query above, we get an error when we try to pull the ID column with the same name.<\/p>\n
Msg 209, Level 16, State 1, Line 2<\/p>\n
Ambiguous column name \u2018ID\u2019.<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
In today’s article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables. Join and Inner Join mean the same thing, we can get the same result by typing both ways. Before using Inner Join, we need to find common columns to join the tables. As …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":366,"featured_media":54823,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-54818","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"\nPostgreSQL Inner Join - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Inner Join - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-29T19:09:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-29T19:11:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png\" \/>\n\t<meta property=\"og:image:width\" content=\"575\" \/>\n\t<meta property=\"og:image:height\" content=\"302\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL Inner Join\",\"datePublished\":\"2023-07-29T19:09:46+00:00\",\"dateModified\":\"2023-07-29T19:11:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\"},\"wordCount\":398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\",\"name\":\"PostgreSQL Inner Join - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png\",\"datePublished\":\"2023-07-29T19:09:46+00:00\",\"dateModified\":\"2023-07-29T19:11:16+00:00\",\"description\":\"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png\",\"width\":575,\"height\":302},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Inner Join\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL Inner Join - Database Tutorials","description":"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.","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:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL Inner Join - Database Tutorials","og_description":"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/","og_site_name":"Database Tutorials","article_published_time":"2023-07-29T19:09:46+00:00","article_modified_time":"2023-07-29T19:11:16+00:00","og_image":[{"width":575,"height":302,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL Inner Join","datePublished":"2023-07-29T19:09:46+00:00","dateModified":"2023-07-29T19:11:16+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/"},"wordCount":398,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/","url":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/","name":"PostgreSQL Inner Join - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png","datePublished":"2023-07-29T19:09:46+00:00","dateModified":"2023-07-29T19:11:16+00:00","description":"In today's article, we will explain the Use of Inner Join, which allows us to see the intersecting data of two tables.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/07\/Ekran-goruntusu-2023-07-29-220840.png","width":575,"height":302},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/07\/29\/postgresql-inner-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Inner Join"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54818"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54818\/revisions"}],"predecessor-version":[{"id":54824,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54818\/revisions\/54824"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54823"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}