{"id":13800,"date":"2022-10-05T10:41:46","date_gmt":"2022-10-05T05:11:46","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/"},"modified":"2022-10-05T10:41:46","modified_gmt":"2022-10-05T05:11:46","slug":"solved-showing-records-from-two-sql-table-alternatively-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/","title":{"rendered":"[Solved] showing records from two sql table alternatively [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-20466624\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"20466624\" data-parentid=\"20466416\" 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>Use a sql select query similar to this&#8230;.<\/p>\n<pre><code>select * from EmployeeDetails ed\nleft join EmployeeEntries ee on ee.EmpId = ed.EmpId\n<\/code><\/pre>\n<p>Note that this query will return all entries for each employee and each record will have the employee details as well. That means the employee details will be repeated for each entry the have in the EmployeeEntries table<br \/>\nThen use a web server control that handles grouping such as the ListView, for more info, read this&#8230;.<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/system.windows.forms.listview.groups(v=vs.110).aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/system.windows.forms.listview.groups(v=vs.110).aspx<\/a><\/p>\n<p>Which will produce something similar to this&#8230;<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/web.archive.org\/web\/20161106210140\/http:\/\/aspnet.4guysfromrolla.com\/images\/ListView\/05.01.png\">https:\/\/web.archive.org\/web\/20161106210140\/http:\/\/aspnet.4guysfromrolla.com\/images\/ListView\/05.01.png<\/a><\/p>\n<p>Your question is too abstract and there&#8217;s a lot to cover but if you still don&#8217;t get how to achieve this, then read this tutorial&#8230;<\/p>\n<p><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/web.archive.org\/web\/20210301194237\/https:\/\/www.4guysfromrolla.com\/articles\/091708-1.aspx\">https:\/\/web.archive.org\/web\/20210301194237\/https:\/\/www.4guysfromrolla.com\/articles\/091708-1.aspx<\/a><\/p>\n<p>Hope it helps,<br \/>\nLeo.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved showing records from two sql table alternatively [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] Use a sql select query similar to this&#8230;. select * from EmployeeDetails ed left join EmployeeEntries ee on ee.EmpId = ed.EmpId Note that this query will return all entries for each employee and each record will have the employee details as well. That means the employee details will be repeated for each entry the &#8230; <a title=\"[Solved] showing records from two sql table alternatively [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\" aria-label=\"More on [Solved] showing records from two sql table alternatively [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":[751,341,500],"class_list":["post-13800","post","type-post","status-publish","format-standard","hentry","category-solved","tag-asp-net","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] showing records from two sql table alternatively [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-showing-records-from-two-sql-table-alternatively-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] showing records from two sql table alternatively [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Use a sql select query similar to this&#8230;. select * from EmployeeDetails ed left join EmployeeEntries ee on ee.EmpId = ed.EmpId Note that this query will return all entries for each employee and each record will have the employee details as well. That means the employee details will be repeated for each entry the ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-05T05:11:46+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-showing-records-from-two-sql-table-alternatively-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] showing records from two sql table alternatively [closed]\",\"datePublished\":\"2022-10-05T05:11:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\"},\"wordCount\":160,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"asp.net\",\"sql\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\",\"name\":\"[Solved] showing records from two sql table alternatively [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-10-05T05:11:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] showing records from two sql table alternatively [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=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] showing records from two sql table alternatively [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-showing-records-from-two-sql-table-alternatively-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] showing records from two sql table alternatively [closed] - JassWeb","og_description":"[ad_1] Use a sql select query similar to this&#8230;. select * from EmployeeDetails ed left join EmployeeEntries ee on ee.EmpId = ed.EmpId Note that this query will return all entries for each employee and each record will have the employee details as well. That means the employee details will be repeated for each entry the ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-05T05:11:46+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-showing-records-from-two-sql-table-alternatively-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] showing records from two sql table alternatively [closed]","datePublished":"2022-10-05T05:11:46+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/"},"wordCount":160,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["asp.net","sql","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/","name":"[Solved] showing records from two sql table alternatively [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-05T05:11:46+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-showing-records-from-two-sql-table-alternatively-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] showing records from two sql table alternatively [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=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","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\/13800","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=13800"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/13800\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=13800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=13800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=13800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}