{"id":12413,"date":"2024-03-14T15:48:48","date_gmt":"2024-03-14T15:48:48","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/"},"modified":"2025-08-05T01:14:58","modified_gmt":"2025-08-05T01:14:58","slug":"how-can-two-rows-be-combined-into-one-in-sql","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/","title":{"rendered":"Combine Two SQL Rows into One: JOIN &#038; UNION"},"content":{"rendered":"<p>You can use either JOIN clause or UNION clause to combine two lines into one.<\/p>\n<p>If you have two tables, each with one row of data, you can combine them into one row using a JOIN clause. Here is an example:<\/p>\n<p>Table 1:<\/p>\n<pre class=\"post-pre\"><code>id | name\r\n---|------\r\n1  | John\r\n<\/code><\/pre>\n<p>Table 2:<\/p>\n<pre class=\"post-pre\"><code>id | age\r\n---|-----\r\n1  | 25\r\n<\/code><\/pre>\n<p>The combined result:<\/p>\n<pre class=\"post-pre\"><code>id | name | age\r\n---|------|-----\r\n1  | John | 25\r\n<\/code><\/pre>\n<p>You can use the following SQL query to merge:<\/p>\n<pre class=\"post-pre\"><code>SELECT table1.id, table1.name, table2.age\r\nFROM table1\r\nJOIN table2 ON table1.id = table2.id;\r\n<\/code><\/pre>\n<p>If you want to merge two rows from two tables into one row, but there are no common columns to join on, you can use the UNION clause. Here is an example:<\/p>\n<p>Table 1:<\/p>\n<pre class=\"post-pre\"><code>col1 | col2\r\n-----|------\r\nA    | 1\r\n<\/code><\/pre>\n<p>Table 2:<\/p>\n<pre class=\"post-pre\"><code>col3 | col4\r\n-----|------\r\nB    | 2\r\n<\/code><\/pre>\n<p>The combined result:<\/p>\n<pre class=\"post-pre\"><code>col1 | col2 | col3 | col4\r\n-----|------|------|-----\r\nA    | 1    |      |\r\n     |      | B    | 2\r\n<\/code><\/pre>\n<p>You can merge using the following SQL query statement:<\/p>\n<pre class=\"post-pre\"><code>SELECT col1, col2, NULL AS col3, NULL AS col4\r\nFROM table1\r\nUNION ALL\r\nSELECT NULL AS col1, NULL AS col2, col3, col4\r\nFROM table2;\r\n<\/code><\/pre>\n<p>The above are two common methods of merging two lines into one, the specific way of merging depends on your data structure and requirements.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can use either JOIN clause or UNION clause to combine two lines into one. If you have two tables, each with one row of data, you can combine them into one row using a JOIN clause. Here is an example: Table 1: id | name &#8212;|&#8212;&#8212; 1 | John Table 2: id | age [&hellip;]<\/p>\n","protected":false},"author":10,"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":[16267,766,5115,10242,7394],"class_list":["post-12413","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-combine-rows","tag-database-queries","tag-sql-join","tag-sql-merge","tag-sql-union"],"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>Combine Two SQL Rows into One: JOIN &amp; UNION - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.\" \/>\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-two-rows-be-combined-into-one-in-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Combine Two SQL Rows into One: JOIN &amp; UNION\" \/>\n<meta property=\"og:description\" content=\"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\" \/>\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-14T15:48:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T01:14:58+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\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=\"Jackson Davis\" \/>\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-two-rows-be-combined-into-one-in-sql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"Combine Two SQL Rows into One: JOIN &#038; UNION\",\"datePublished\":\"2024-03-14T15:48:48+00:00\",\"dateModified\":\"2025-08-05T01:14:58+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\"},\"wordCount\":133,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"combine rows\",\"Database Queries\",\"SQL join\",\"SQL MERGE\",\"SQL union\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\",\"name\":\"Combine Two SQL Rows into One: JOIN & UNION - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T15:48:48+00:00\",\"dateModified\":\"2025-08-05T01:14:58+00:00\",\"description\":\"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Combine Two SQL Rows into One: JOIN &#038; UNION\"}]},{\"@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\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Combine Two SQL Rows into One: JOIN & UNION - Blog - Silicon Cloud","description":"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.","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-two-rows-be-combined-into-one-in-sql\/","og_locale":"en_US","og_type":"article","og_title":"Combine Two SQL Rows into One: JOIN & UNION","og_description":"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T15:48:48+00:00","article_modified_time":"2025-08-05T01:14:58+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"Combine Two SQL Rows into One: JOIN &#038; UNION","datePublished":"2024-03-14T15:48:48+00:00","dateModified":"2025-08-05T01:14:58+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/"},"wordCount":133,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["combine rows","Database Queries","SQL join","SQL MERGE","SQL union"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/","name":"Combine Two SQL Rows into One: JOIN & UNION - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T15:48:48+00:00","dateModified":"2025-08-05T01:14:58+00:00","description":"Learn how to merge two rows in SQL using JOIN or UNION clauses with practical examples and clear syntax.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-two-rows-be-combined-into-one-in-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Combine Two SQL Rows into One: JOIN &#038; UNION"}]},{"@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\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12413","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=12413"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12413\/revisions"}],"predecessor-version":[{"id":156204,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/12413\/revisions\/156204"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=12413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=12413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=12413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}