{"id":13114,"date":"2024-03-15T01:55:47","date_gmt":"2024-03-15T01:55:47","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/"},"modified":"2025-08-05T11:34:38","modified_gmt":"2025-08-05T11:34:38","slug":"how-can-i-query-for-unique-values-from-two-tables-in-access","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/","title":{"rendered":"Access UNION: Query Unique Values from Two Tables"},"content":{"rendered":"<p>You can use the UNION keyword to query distinct values from two tables. The UNION operator is used to combine the results of two or more SELECT statements and return all unique rows.<\/p>\n<p>For example, if we have two tables, table1 and table2, with the same columns, we can use the following statement to query for unique values in both tables.<\/p>\n<pre class=\"post-pre\"><code>SELECT col1, col2, col3\r\nFROM table1\r\nUNION\r\nSELECT col1, col2, col3\r\nFROM table2;\r\n<\/code><\/pre>\n<p>In this example, col1, col2, and col3 are the column names in the table. The UNION operator will return all non-duplicate rows from both tables.<\/p>\n<p>If you want to return duplicate rows as well, you can use the UNION ALL operator, for example:<\/p>\n<pre class=\"post-pre\"><code>SELECT col1, col2, col3\r\nFROM table1\r\nUNION ALL\r\nSELECT col1, col2, col3\r\nFROM table2;\r\n<\/code><\/pre>\n<p>Please note that the result set of UNION and UNION ALL operators will automatically remove duplicates. If you want to manually remove duplicates, you can use the DISTINCT keyword, for example:<\/p>\n<pre class=\"post-pre\"><code>SELECT DISTINCT col1, col2, col3\r\nFROM (\r\n    SELECT col1, col2, col3\r\n    FROM table1\r\n    UNION\r\n    SELECT col1, col2, col3\r\n    FROM table2\r\n) AS subquery;\r\n<\/code><\/pre>\n<p>In this example, a subquery is used to perform a UNION operation, and then the DISTINCT keyword is used in the outer query to remove duplicate results.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use the UNION keyword to query distinct values from two tables. The UNION operator is used to combine the results of two or more SELECT statements and return all unique rows. For example, if we have two tables, table1 and table2, with the same columns, we can use the following statement to query [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[17379,766,6478,7394,4919],"class_list":["post-13114","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-access-tips","tag-database-queries","tag-microsoft-access","tag-sql-union","tag-unique-values"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Access UNION: Query Unique Values from Two Tables - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Access UNION: Query Unique Values from Two Tables\" \/>\n<meta property=\"og:description\" content=\"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T01:55:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T11:34:38+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\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:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"Access UNION: Query Unique Values from Two Tables\",\"datePublished\":\"2024-03-15T01:55:47+00:00\",\"dateModified\":\"2025-08-05T11:34:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\"},\"wordCount\":170,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Access Tips\",\"Database Queries\",\"Microsoft Access\",\"SQL union\",\"unique values\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\",\"name\":\"Access UNION: Query Unique Values from Two Tables - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T01:55:47+00:00\",\"dateModified\":\"2025-08-05T11:34:38+00:00\",\"description\":\"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Access UNION: Query Unique Values from Two Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Access UNION: Query Unique Values from Two Tables - Blog - Silicon Cloud","description":"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.","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:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/","og_locale":"en_US","og_type":"article","og_title":"Access UNION: Query Unique Values from Two Tables","og_description":"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T01:55:47+00:00","article_modified_time":"2025-08-05T11:34:38+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"Access UNION: Query Unique Values from Two Tables","datePublished":"2024-03-15T01:55:47+00:00","dateModified":"2025-08-05T11:34:38+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/"},"wordCount":170,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Access Tips","Database Queries","Microsoft Access","SQL union","unique values"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/","name":"Access UNION: Query Unique Values from Two Tables - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T01:55:47+00:00","dateModified":"2025-08-05T11:34:38+00:00","description":"Learn to use UNION in Access to retrieve unique values from multiple tables with clear examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-i-query-for-unique-values-from-two-tables-in-access\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Access UNION: Query Unique Values from Two Tables"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13114"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13114\/revisions"}],"predecessor-version":[{"id":156974,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13114\/revisions\/156974"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13114"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}