{"id":7174,"date":"2019-01-05T11:47:41","date_gmt":"2019-01-05T11:47:41","guid":{"rendered":"https:\/\/dbtut.com\/?p=7174"},"modified":"2019-01-05T11:50:52","modified_gmt":"2019-01-05T11:50:52","slug":"ambiguous-column-name-error-and-sql-server-aliastsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/","title":{"rendered":"Ambiguous column name Error and SQL Server Alias(TSQL)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>When reading data from tables, we may need to give different names to tables and columns. We can do this by defining alias to columns or tables.<\/p>\n<p>In our first example we will give different names to the tables.<\/p>\n<p><strong>Example1:<\/strong><\/p>\n<p>We usually need to give Alias when we join the tables.<\/p>\n<p>First, let&#8217;s create two tables as below and add a few records to these tables.<\/p>\n<pre class=\"lang:default decode:true\">USE [TestDB]\r\nGO\r\nCREATE TABLE [dbo].[MyTable_1](\r\n[ID] [int] IDENTITY(1,1) NOT NULL,\r\n[Name] [varchar](50) NULL\r\n) ON [PRIMARY]\r\nGO\r\nCREATE TABLE [dbo].[MyTable_2](\r\n[ID] [int] IDENTITY(1,1) NOT NULL,\r\n[SurName] [varchar](50) NULL,\r\n) ON [PRIMARY]\r\nGO\r\nINSERT INTO [dbo].[MyTableTarget] VALUES ('Nurullah'),('Faruk')\r\nINSERT INTO [dbo].[MyTableSource] VALUES ('CAKIR'),('ERDEM')<\/pre>\n<p>Then try to run the following join query.<\/p>\n<pre class=\"lang:default decode:true\">SELECT [ID],[Name],[Surname] FROM [dbo].[MyTable_1]\r\nINNER JOIN [dbo].[MyTable_2] ON [dbo].[MyTable_1].[ID]=[dbo].[MyTable_2].[ID]<\/pre>\n<p>When we run the query we will get the error as follows.<\/p>\n<p><em>Msg 209, Level 16, State 1, Line 17<\/em><\/p>\n<p><em>Ambiguous column name &#8216;ID&#8217;.<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\" width=\"691\" height=\"166\" \/><\/p>\n<p>The reason for the error is that the ID column exists in both tables.<\/p>\n<p>In this case, the problem will be solved when we write the query using alias. We can use alias as follows.<\/p>\n<pre class=\"lang:default decode:true\">SELECT tbl1.[ID],tbl1.[Name],tbl2.[Surname] FROM [dbo].[MyTable_1] tbl1\r\nINNER JOIN [dbo].[MyTable_2] tbl2 ON tbl1.[ID]=tbl2.[ID]<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/777.png\" width=\"701\" height=\"216\" \/><\/p>\n<p>In the second example we will describe the alias to the columns.<\/p>\n<p><strong>Example2:<\/strong><\/p>\n<p>When joining the first table and the second table, combine the name and surname with the + operator. As a result, let&#8217;s give the column a different name with an alias.<\/p>\n<pre class=\"lang:default decode:true\">SELECT tbl1.[ID],tbl1.[Name] +' '+tbl2.[Surname] AS 'Name_Surname' FROM [dbo].[MyTable_1] tbl1\r\nINNER JOIN [dbo].[MyTable_2] tbl2 ON tbl1.[ID]=tbl2.[ID]<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/629-1.png\" width=\"687\" height=\"158\" \/><\/p>\n<p>&nbsp;<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7174\" class=\"pvc_stats all  \" data-element-id=\"7174\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; When reading data from tables, we may need to give different names to tables and columns. We can do this by defining alias to columns or tables. In our first example we will give different names to the tables. Example1: We usually need to give Alias when we join the tables. First, let&#8217;s create &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7174\" class=\"pvc_stats all  \" data-element-id=\"7174\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"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":[3,1596],"tags":[398,400,399],"class_list":["post-7174","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-alias","tag-ambiguous-column-name","tag-sql-server-alias"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":1316,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Ambiguous column name Error and SQL Server Aliases(TSQL)\" \/>\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\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Ambiguous column name Error and SQL Server Aliases(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-05T11:47:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-05T11:50:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Ambiguous column name Error and SQL Server Alias(TSQL)\",\"datePublished\":\"2019-01-05T11:47:41+00:00\",\"dateModified\":\"2019-01-05T11:50:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\"},\"wordCount\":186,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\",\"keywords\":[\"alias\",\"Ambiguous column name\",\"sql server alias\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\",\"name\":\"Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\",\"datePublished\":\"2019-01-05T11:47:41+00:00\",\"dateModified\":\"2019-01-05T11:50:52+00:00\",\"description\":\"Ambiguous column name Error and SQL Server Aliases(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png\",\"width\":1024,\"height\":246},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Ambiguous column name Error and SQL Server Alias(TSQL)\"}]},{\"@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\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials","description":"Ambiguous column name Error and SQL Server Aliases(TSQL)","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\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/","og_locale":"en_US","og_type":"article","og_title":"Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials","og_description":"Ambiguous column name Error and SQL Server Aliases(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-05T11:47:41+00:00","article_modified_time":"2019-01-05T11:50:52+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Ambiguous column name Error and SQL Server Alias(TSQL)","datePublished":"2019-01-05T11:47:41+00:00","dateModified":"2019-01-05T11:50:52+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/"},"wordCount":186,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png","keywords":["alias","Ambiguous column name","sql server alias"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/","name":"Ambiguous column name Error and SQL Server Alias(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png","datePublished":"2019-01-05T11:47:41+00:00","dateModified":"2019-01-05T11:50:52+00:00","description":"Ambiguous column name Error and SQL Server Aliases(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/984.png","width":1024,"height":246},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/05\/ambiguous-column-name-error-and-sql-server-aliastsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Ambiguous column name Error and SQL Server Alias(TSQL)"}]},{"@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\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7174","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=7174"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7174\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}