{"id":191074,"date":"2024-11-05T09:56:00","date_gmt":"2024-11-05T08:56:00","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=191074"},"modified":"2024-11-07T14:51:25","modified_gmt":"2024-11-07T13:51:25","slug":"all-about-sql-union","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/all-about-sql-union","title":{"rendered":"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"191074\" class=\"elementor elementor-191074\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0f37c32 e-flex e-con-boxed e-con\" data-id=\"0f37c32\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2fef56d elementor-widget elementor-widget-text-editor\" data-id=\"2fef56d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><strong>In the fast-paced world of data analysis, efficiency is key to maintaining productivity. As a Business Analyst, you&#8217;re constantly tasked with retrieving, cleaning, and analyzing large datasets to provide actionable insights for decision-makers. However, managing multiple tables, especially when they contain related data, can lead to redundancy and inefficiencies in your workflow. One simple yet powerful way to streamline these processes is by reducing the number of steps required to retrieve and combine data, allowing you to spend more time analyzing and less time preparing your <a href=\"https:\/\/datascientest.com\/en\/datasets-top-5-places-to-find-quality-datasets\">datasets<\/a>.<\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8914dd9 elementor-widget elementor-widget-text-editor\" data-id=\"8914dd9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\"><a href=\"https:\/\/datascientest.com\/en\/sql-learn-all-about-the-programming-language-for-databases\">SQL<\/a> offers several functionalities that can help you achieve this, and one of the most effective tools for consolidating data from multiple tables is the <\/span><b>SQL UNION clause<\/b><span style=\"font-weight: 400;\">. In this blog post, we\u2019ll explore how using UNION can enhance your workflow by combining data from similar tables into one unified dataset. By the end of this post, you\u2019ll understand how UNION differs from JOIN, and how embracing SQL UNION can lead to more efficient and effective data analysis.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2df4d97 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"2df4d97\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-analyst-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn all about SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d24c394 e-flex e-con-boxed e-con\" data-id=\"d24c394\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-cbf94a7 elementor-widget elementor-widget-heading\" data-id=\"cbf94a7\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h3 class=\"elementor-heading-title elementor-size-default\">The Scenario: Merging Business Lines<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c9736c4 elementor-widget elementor-widget-text-editor\" data-id=\"c9736c4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<span style=\"font-weight: 400;\">Let\u2019s imagine a real-world scenario. Your company operates across multiple business lines, and each line maintains separate product information tables. Specifically, you have two key tables:<\/span>\n<ol>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Product Information Table for Business Line A [<\/b><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">product_info_a<\/span><\/i><\/span><b>]<\/b><span style=\"font-weight: 400;\">: Contains details for all products in Business Line A, including attributes such as product weight, height, cost, and price.<\/span><\/li>\n \t<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Product Information Table for Business Line B [<\/b><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">product_info_b<\/span><\/i><\/span><b>]<\/b><span style=\"font-weight: 400;\">: Contains the same columns as the table for Business Line A but includes details for only one product in Business Line B.<\/span><\/li>\n<\/ol>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d6a9a32 elementor-widget elementor-widget-image\" data-id=\"d6a9a32\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1326\" height=\"222\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image3.webp\" class=\"attachment-full size-full wp-image-191078\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image3.webp 1326w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image3-300x50.webp 300w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image3-1024x171.webp 1024w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image3-768x129.webp 768w\" sizes=\"(max-width: 1326px) 100vw, 1326px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Image 1. Table <span style=\"color: #808080\"><i>product_info_a<\/i><\/span><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-05d67dc e-flex e-con-boxed e-con\" data-id=\"05d67dc\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3f1d88c elementor-widget elementor-widget-image\" data-id=\"3f1d88c\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1326\" height=\"98\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image1.webp\" class=\"attachment-full size-full wp-image-191079\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image1.webp 1326w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image1-300x22.webp 300w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image1-1024x76.webp 1024w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image1-768x57.webp 768w\" sizes=\"(max-width: 1326px) 100vw, 1326px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Image 2. Table <span style=\"color: #808080\"><i>product_info_b<\/i><\/span><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0247228 elementor-widget elementor-widget-text-editor\" data-id=\"0247228\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">A few months ago, after conducting a market analysis and strategic planning session, your company decided to merge Business Line B with Business Line A to streamline operations. However, the workflow hasn\u2019t adapted to this change\u2014employees continue to retrieve data from both tables and conduct analyses separately, leading to inefficiencies in their processes.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-93538ba e-flex e-con-boxed e-con\" data-id=\"93538ba\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a54db7b elementor-widget elementor-widget-heading\" data-id=\"a54db7b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Introducing SQL UNION<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f999905 elementor-widget elementor-widget-text-editor\" data-id=\"f999905\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">This is where the <\/span><b>SQL UNION clause<\/b><span style=\"font-weight: 400;\"> comes into play. By utilizing UNION, you can seamlessly append the data from Business Line B to the Product Information Table for Business Line A, creating a single consolidated dataset that you can use for analysis. Instead of querying two tables separately, combining the data with UNION reduces the complexity of your workflow and saves valuable time.<\/span><\/p><p><span style=\"font-weight: 400;\">Let\u2019s take a look at how this works. The SQL UNION clause is used to combine the results of two or more SELECT statements into a single result set. Each SELECT statement must have the same number of columns, and the columns must have compatible data types. If there are any duplicate rows between the two tables, UNION will automatically remove them unless you use the UNION ALL clause, which preserves duplicates.<\/span><\/p><p><span style=\"font-weight: 400;\">Here\u2019s the SQL script that shows how to use UNION to merge the two product information tables:<\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">SELECT product_id, product_name, weight, height, cost, price\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM product_info_a\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">UNION SELECT product_id, product_name, weight, height, cost, price\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM product_info_b;<\/span><\/i><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df796c6 elementor-widget elementor-widget-image\" data-id=\"df796c6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1326\" height=\"262\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image2.webp\" class=\"attachment-full size-full wp-image-191083\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image2.webp 1326w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image2-300x59.webp 300w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image2-1024x202.webp 1024w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image2-768x152.webp 768w\" sizes=\"(max-width: 1326px) 100vw, 1326px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Image 3. <span style=\"color: #808080\"><i>Union<\/i><\/span><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0d688c7 elementor-widget elementor-widget-text-editor\" data-id=\"0d688c7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In this example, you now have a unified product information table that combines data from both Business Line A and Business Line B. Instead of pulling data from two separate tables, this consolidated view allows you to analyze your products in a single query, which greatly simplifies the process.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9246e2f elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"9246e2f\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-analyst-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Mastering SQL<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-9832501 e-flex e-con-boxed e-con\" data-id=\"9832501\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ce9e857 elementor-widget elementor-widget-heading\" data-id=\"ce9e857\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">UNION vs. JOIN: What\u2019s the Difference?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c33834c elementor-widget elementor-widget-text-editor\" data-id=\"c33834c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">At this point, you might be wondering: what\u2019s the difference between <\/span><b>UNION<\/b><span style=\"font-weight: 400;\"> and <\/span><b>JOIN<\/b><span style=\"font-weight: 400;\">? Both are used to combine data from multiple tables, but they do so in very different ways.<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><b>UNION<\/b><span style=\"font-weight: 400;\"> is used when you have two tables with the same structure and you want to append one table\u2019s data to the other. It\u2019s like stacking one dataset on top of another.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><b>JOIN<\/b><span style=\"font-weight: 400;\">, on the other hand, is used to merge two tables based on a related column (a foreign key or common field). JOINs are useful when you need to combine data from tables with different structures by matching rows based on a specific relationship.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5b69782 elementor-widget elementor-widget-text-editor\" data-id=\"5b69782\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">For instance, if you had a separate table for product categories and you wanted to join it with your product information table, you would use an SQL JOIN rather than UNION.<\/span><\/p><p><span style=\"font-weight: 400;\">Here\u2019s a simple example of a JOIN:<\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">SELECT p.product_name, p.price, c.category_name\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM product_info_a p\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">JOIN product_categories c\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">ON p.product_id = c.product_id;<\/span><\/i><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1daf954 elementor-widget elementor-widget-image\" data-id=\"1daf954\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"446\" height=\"262\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image4.webp\" class=\"attachment-full size-full wp-image-191090\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image4.webp 446w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image4-300x176.webp 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Image 4. Table <span style=\"color: #808080\"><i>product_categories<\/i><\/span><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f80105b e-flex e-con-boxed e-con\" data-id=\"f80105b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c0ab646 elementor-widget elementor-widget-image\" data-id=\"c0ab646\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"666\" height=\"220\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image5.webp\" class=\"attachment-full size-full wp-image-191095\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image5.webp 666w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image5-300x99.webp 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">Image 5. <span style=\"color: #808080\"><i>Join<\/i><\/span><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8062bcd elementor-widget elementor-widget-text-editor\" data-id=\"8062bcd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">In this case, you\u2019re merging the product information with the corresponding category information by matching the <span style=\"color: #339966;\"><em>product_id<\/em><\/span> columns from both tables. The key difference here is that JOIN connects data based on relationships between the tables, while UNION simply appends rows from two similar tables.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ae8f59 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"0ae8f59\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-analyst-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Know how to use SQL for data analysis<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-caf1d66 e-flex e-con-boxed e-con\" data-id=\"caf1d66\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-db3c7c9 elementor-widget elementor-widget-heading\" data-id=\"db3c7c9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Practical Example: Streamlining Your Workflow<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a09c9bb elementor-widget elementor-widget-text-editor\" data-id=\"a09c9bb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Now, let\u2019s put this into the context of streamlining your workflow. Suppose you\u2019ve been tasked with analyzing the total value of products across both Business Line A and Business Line B. Without UNION, you would need to run separate queries for each business line and then manually combine the results in a spreadsheet or another tool. This would not only be time-consuming but also error-prone.<\/span><\/p><p><span style=\"font-weight: 400;\">By using UNION, you can consolidate your product data into one query, making your analysis faster and more accurate. Here\u2019s how you could calculate the total product value for both business lines in one query:<\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">SELECT SUM(cost) AS total_cost, SUM(price) AS total_price\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM (\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">SELECT cost, price\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM product_info_a\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">UNION SELECT cost, price\u00a0<\/span><\/i><\/span><\/p><p><span style=\"color: #808080;\"><i><span style=\"font-weight: 400;\">FROM product_info_b ) AS combined_data;<\/span><\/i><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a4cf59 elementor-widget elementor-widget-image\" data-id=\"3a4cf59\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"446\" height=\"94\" src=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image6.webp\" class=\"attachment-full size-full wp-image-191099\" alt=\"\" srcset=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/image6.webp 446w, https:\/\/datascientest.com\/en\/files\/2024\/11\/image6-300x63.webp 300w\" sizes=\"(max-width: 446px) 100vw, 446px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-191ba32 elementor-widget elementor-widget-text-editor\" data-id=\"191ba32\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">This query calculates the total cost and price for all products across both business lines, reducing the need for multiple steps in your analysis and ensuring consistency in your results.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-53ff6c9 e-flex e-con-boxed e-con\" data-id=\"53ff6c9\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5ed7bc6 elementor-widget elementor-widget-heading\" data-id=\"5ed7bc6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f404ccb elementor-widget elementor-widget-text-editor\" data-id=\"f404ccb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Incorporating <strong>SQL functionalities<\/strong> like UNION into your workflow can significantly enhance efficiency and improve your overall data analysis process. By consolidating data from multiple tables into a single result set, you can reduce redundancy, eliminate manual data handling, and streamline your operations. UNION is particularly useful when you need to combine data from tables with the same structure, helping you <strong>create unified datasets<\/strong> <strong>for more accurate and faster analysis<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">In addition to the time savings, using UNION can also help minimize the risk of errors that come from handling data separately. In the fast-paced <a href=\"https:\/\/datascientest.com\/en\/business-analyst-definition-missions-training-salary\">environment of business analysis<\/a>, this leads to more reliable insights and better decision-making. So, next time you find yourself working with multiple tables that share the same structure, consider using SQL UNION to simplify your workflow and drive better results!<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8fb9415 elementor-align-center button-principal elementor-widget elementor-widget-button\" data-id=\"8fb9415\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-md\" href=\"https:\/\/datascientest.com\/en\/data-analyst-course\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn SQL with DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-46f6d6a e-flex e-con-boxed e-con\" data-id=\"46f6d6a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-23e912f elementor-widget elementor-widget-html\" data-id=\"23e912f\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"What is SQL UNION?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"SQL UNION is an operator used to combine the results of two or more SELECT queries into a single result. It removes duplicate records by default in the final result.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"How to use SQL UNION?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"To use SQL UNION, simply place the UNION operator between two SELECT queries. For example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"What is the difference between UNION and UNION ALL?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"UNION removes duplicate records, while UNION ALL includes all results, including duplicates. UNION ALL is faster as it does not require sorting to eliminate duplicates.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"What are the conditions for using SQL UNION?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Queries combined with UNION must have the same number of columns, with compatible data types in each corresponding column.\"\r\n      }\r\n    },\r\n    {\r\n      \"@type\": \"Question\",\r\n      \"name\": \"How to optimize a query using SQL UNION?\",\r\n      \"acceptedAnswer\": {\r\n        \"@type\": \"Answer\",\r\n        \"text\": \"Use UNION ALL if you do not need to remove duplicates, as it avoids additional sorting. Ensure that indexed columns are appropriately used in each subquery as well.\"\r\n      }\r\n    }\r\n  ]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>In the fast-paced world of data analysis, efficiency is key to maintaining productivity. As a Business Analyst, you&#8217;re constantly tasked with retrieving, cleaning, and analyzing large datasets to provide actionable insights for decision-makers. However, managing multiple tables, especially when they contain related data, can lead to redundancy and inefficiencies in your workflow. One simple yet [&hellip;]<\/p>\n","protected":false},"author":99,"featured_media":191191,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table<\/title>\n<meta name=\"description\" content=\"Discover everithing about SQL UNION, essential syntax, practical examples, and expert tips for efficient data combination in SQL.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/all-about-sql-union\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table\" \/>\n<meta property=\"og:description\" content=\"In the fast-paced world of data analysis, efficiency is key to maintaining productivity. As a Business Analyst, you&#039;re constantly tasked with retrieving,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/all-about-sql-union\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-11-05T08:56:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-07T13:51:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/11\/Schema_JOIN-vs.-UNION.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Alex Hsu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alex Hsu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/all-about-sql-union#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/all-about-sql-union\"},\"author\":{\"name\":\"Alex Hsu\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/3699921acd6535a6f0a0b0a4cc1b52e0\"},\"headline\":\"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table\",\"datePublished\":\"2024-11-05T08:56:00+00:00\",\"dateModified\":\"2024-11-07T13:51:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/all-about-sql-union\"},\"wordCount\":1138,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/all-about-sql-union#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/all-about-sql-union\",\"url\":\"https:\/\/datascientest.com\/en\/all-about-sql-union\",\"name\":\"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-11-05T08:56:00+00:00\",\"dateModified\":\"2024-11-07T13:51:25+00:00\",\"description\":\"Discover everithing about SQL UNION, essential syntax, practical examples, and expert tips for efficient data combination in SQL.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/all-about-sql-union\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/3699921acd6535a6f0a0b0a4cc1b52e0\",\"name\":\"Alex Hsu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f1076555f6e3dffa5f499a14243f9e46?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f1076555f6e3dffa5f499a14243f9e46?s=96&d=mm&r=g\",\"caption\":\"Alex Hsu\"},\"description\":\"Alex (Yu-Hao) Hsu is a data-driven professional with extensive experience in data analysis, visualization, and statistics, currently working as a Production Planning Engineer at TSMC. With a background in prominent companies like Amazon and BNP Paribas, Alex is skilled in various analytics tools, including Python, R, SQL, Power BI, and Tableau. He is dedicated to continuous learning in data science, evidenced by his advanced studies in machine learning and deep learning, and he actively shares SQL insights to help others enhance their data skills.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/alexhsu-analyst\/\"],\"url\":\"https:\/\/datascientest.com\/en\/author\/alexhsu\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table","description":"Discover everithing about SQL UNION, essential syntax, practical examples, and expert tips for efficient data combination in SQL.","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:\/\/datascientest.com\/en\/all-about-sql-union","og_locale":"en_GB","og_type":"article","og_title":"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table","og_description":"In the fast-paced world of data analysis, efficiency is key to maintaining productivity. As a Business Analyst, you're constantly tasked with retrieving,","og_url":"https:\/\/datascientest.com\/en\/all-about-sql-union","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-11-05T08:56:00+00:00","article_modified_time":"2024-11-07T13:51:25+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/datascientest.com\/en\/files\/2024\/11\/Schema_JOIN-vs.-UNION.webp","type":"image\/webp"}],"author":"Alex Hsu","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Alex Hsu","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/all-about-sql-union#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/all-about-sql-union"},"author":{"name":"Alex Hsu","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/3699921acd6535a6f0a0b0a4cc1b52e0"},"headline":"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table","datePublished":"2024-11-05T08:56:00+00:00","dateModified":"2024-11-07T13:51:25+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/all-about-sql-union"},"wordCount":1138,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/all-about-sql-union#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/all-about-sql-union","url":"https:\/\/datascientest.com\/en\/all-about-sql-union","name":"SQL UNION: A Comprehensive Guide to Merging Data Across Multiple Table","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-11-05T08:56:00+00:00","dateModified":"2024-11-07T13:51:25+00:00","description":"Discover everithing about SQL UNION, essential syntax, practical examples, and expert tips for efficient data combination in SQL.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/all-about-sql-union"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/3699921acd6535a6f0a0b0a4cc1b52e0","name":"Alex Hsu","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f1076555f6e3dffa5f499a14243f9e46?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f1076555f6e3dffa5f499a14243f9e46?s=96&d=mm&r=g","caption":"Alex Hsu"},"description":"Alex (Yu-Hao) Hsu is a data-driven professional with extensive experience in data analysis, visualization, and statistics, currently working as a Production Planning Engineer at TSMC. With a background in prominent companies like Amazon and BNP Paribas, Alex is skilled in various analytics tools, including Python, R, SQL, Power BI, and Tableau. He is dedicated to continuous learning in data science, evidenced by his advanced studies in machine learning and deep learning, and he actively shares SQL insights to help others enhance their data skills.","sameAs":["https:\/\/www.linkedin.com\/in\/alexhsu-analyst\/"],"url":"https:\/\/datascientest.com\/en\/author\/alexhsu"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/191074"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/99"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=191074"}],"version-history":[{"count":39,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/191074\/revisions"}],"predecessor-version":[{"id":191122,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/191074\/revisions\/191122"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/191191"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=191074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=191074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=191074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}