{"id":10135,"date":"2022-09-22T10:45:30","date_gmt":"2022-09-22T05:15:30","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/"},"modified":"2022-09-22T10:45:30","modified_gmt":"2022-09-22T05:15:30","slug":"solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/","title":{"rendered":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-30852440\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"30852440\" data-parentid=\"30849623\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>After re-reading your question, I think this is what you are looking for:<\/p>\n<pre><code>SELECT  e.Department_ID ,\n        e.Employee_Name AS Col1 ,\n        e.Total_Hours\nFROM    Employee e\nUNION ALL\nSELECT  d.Department_ID ,\n        d.Department_Name AS Col1 ,\n        SUM(e.Total_Hours)\nFROM    Employee e\n        JOIN Department d ON e.Department_ID = d.Department_ID\nGROUP BY d.Department_ID ,\n        d.Department_Name\nORDER BY Department_ID ASC ,\n        Total_Hours DESC\n<\/code><\/pre>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/sqlfiddle.com\/#!3\/67e4c1\/13\/0\">SQL Fiddle Demo<\/a><\/p>\n<p>Based on provided table structure and sample data, I feel that you may want to redesign your table something similar to my example above. It seems to violate the normal form and seems to be missing primary key in your tables. I strongly urge you to redesign your table so it saves you some headaches in the future. Meanwhile, here is how you can achieve your desired output: <\/p>\n<pre><code>SELECT  e.Employee_Name AS Col1 ,\n        e.Total_Hours,\n        e.Department_Name as Sort_Field\nFROM    Employee e\nUNION ALL\nSELECT  d.Department_Name AS Col1 ,\n        d.Total_Hours,\n        UPPER(d.Department_Name) as Sort_Field     \nFROM   Department d\nORDER BY Sort_Field,Total_Hours desc\n<\/code><\/pre>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/sqlfiddle.com\/#!3\/e7825\/6\/0\">Sample Data Solution<\/a><\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] After re-reading your question, I think this is what you are looking for: SELECT e.Department_ID , e.Employee_Name AS Col1 , e.Total_Hours FROM Employee e UNION ALL SELECT d.Department_ID , d.Department_Name AS Col1 , SUM(e.Total_Hours) FROM Employee e JOIN Department d ON e.Department_ID = d.Department_ID GROUP BY d.Department_ID , d.Department_Name ORDER BY Department_ID ASC , &#8230; <a title=\"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\" aria-label=\"More on [Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[341,500],"class_list":["post-10135","post","type-post","status-publish","format-standard","hentry","category-solved","tag-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] After re-reading your question, I think this is what you are looking for: SELECT e.Department_ID , e.Employee_Name AS Col1 , e.Total_Hours FROM Employee e UNION ALL SELECT d.Department_ID , d.Department_Name AS Col1 , SUM(e.Total_Hours) FROM Employee e JOIN Department d ON e.Department_ID = d.Department_ID GROUP BY d.Department_ID , d.Department_Name ORDER BY Department_ID ASC , ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-22T05:15:30+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]\",\"datePublished\":\"2022-09-22T05:15:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\"},\"wordCount\":119,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"sql\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\",\"name\":\"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-22T05:15:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb","og_description":"[ad_1] After re-reading your question, I think this is what you are looking for: SELECT e.Department_ID , e.Employee_Name AS Col1 , e.Total_Hours FROM Employee e UNION ALL SELECT d.Department_ID , d.Department_Name AS Col1 , SUM(e.Total_Hours) FROM Employee e JOIN Department d ON e.Department_ID = d.Department_ID GROUP BY d.Department_ID , d.Department_Name ORDER BY Department_ID ASC , ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-22T05:15:30+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]","datePublished":"2022-09-22T05:15:30+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/"},"wordCount":119,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["sql","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/","name":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-22T05:15:30+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-joining-two-sql-tables-in-microsoft-sql-server-2012-to-get-a-certain-format-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Joining two SQL tables in Microsoft SQL server 2012 to get a certain format [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=10135"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/10135\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=10135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=10135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=10135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}