{"id":8377,"date":"2022-09-13T07:10:32","date_gmt":"2022-09-13T01:40:32","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/"},"modified":"2022-09-13T07:10:32","modified_gmt":"2022-09-13T01:40:32","slug":"solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/","title":{"rendered":"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-13572098\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"13572098\" data-parentid=\"13571932\" 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<pre class=\"lang-sql prettyprint-override\"><code>SELECT *\nFROM   section_user_map\n  JOIN users        USING (UID)\n  JOIN verification USING (UID)\nWHERE  SectionID = 65\n   AND CompleteDate BETWEEN '2012-05-09 12:00:00'\n                        AND '2012-05-11 12:00:00'\n<\/code><\/pre>\n<p>See it on <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/sqlfiddle.com\/#!2\/25a7c\/1\/0\">sqlfiddle<\/a>.<\/p>\n<p>No <code>UNION<\/code> required.  Outer join would only be required if you still want to return results for users who do not exist in one (or both) of the <code>users<\/code> or <code>verification<\/code> tables.<\/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 MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] SELECT * FROM section_user_map JOIN users USING (UID) JOIN verification USING (UID) WHERE SectionID = 65 AND CompleteDate BETWEEN &#8216;2012-05-09 12:00:00&#8217; AND &#8216;2012-05-11 12:00:00&#8217; See it on sqlfiddle. No UNION required. Outer join would only be required if you still want to return results for users who do not exist in one (or both) &#8230; <a title=\"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\" aria-label=\"More on [Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables\">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":[534,340,339,2376],"class_list":["post-8377","post","type-post","status-publish","format-standard","hentry","category-solved","tag-join","tag-mysql","tag-php","tag-union"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - 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-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] SELECT * FROM section_user_map JOIN users USING (UID) JOIN verification USING (UID) WHERE SectionID = 65 AND CompleteDate BETWEEN &#039;2012-05-09 12:00:00&#039; AND &#039;2012-05-11 12:00:00&#039; See it on sqlfiddle. No UNION required. Outer join would only be required if you still want to return results for users who do not exist in one (or both) ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-13T01:40:32+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<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables\",\"datePublished\":\"2022-09-13T01:40:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\"},\"wordCount\":79,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"join\",\"mysql\",\"php\",\"union\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\",\"name\":\"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-13T01:40:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables\"}]},{\"@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] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - 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-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - JassWeb","og_description":"[ad_1] SELECT * FROM section_user_map JOIN users USING (UID) JOIN verification USING (UID) WHERE SectionID = 65 AND CompleteDate BETWEEN '2012-05-09 12:00:00' AND '2012-05-11 12:00:00' See it on sqlfiddle. No UNION required. Outer join would only be required if you still want to return results for users who do not exist in one (or both) ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/","og_site_name":"JassWeb","article_published_time":"2022-09-13T01:40:32+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables","datePublished":"2022-09-13T01:40:32+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/"},"wordCount":79,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["join","mysql","php","union"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/","url":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/","name":"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-13T01:40:32+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-search-for-user-id-in-one-table-to-search-for-data-in-2-other-tables-then-show-data-from-all-3-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MYSQL: Search for User ID in one table to search for data in 2 other tables, then show data from all 3 tables"}]},{"@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\/8377","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=8377"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/8377\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=8377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=8377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=8377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}