{"id":1435,"date":"2025-07-18T02:30:19","date_gmt":"2025-07-18T02:30:19","guid":{"rendered":"https:\/\/kompetendigital.com\/blog\/?p=1435"},"modified":"2025-07-18T02:50:24","modified_gmt":"2025-07-18T02:50:24","slug":"cara-merge-data-di-sql","status":"publish","type":"post","link":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/","title":{"rendered":"Cara Merge Data di SQL"},"content":{"rendered":"\n<p>Menggabungkan atau <em>merge<\/em> data di SQL adalah keterampilan penting bagi siapa saja yang bekerja dengan basis data. Baik Anda seorang analis data, pengembang backend, atau sekadar pengguna Excel yang ingin naik level, memahami cara merge data akan membantu Anda mengelola informasi dengan lebih efisien. Artikel ini akan membahas secara lengkap dan mudah dipahami bagaimana cara melakukan merge data di SQL.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#Apa_Itu_Merge_Data_di_SQL\" >Apa Itu Merge Data di SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#1_Menggunakan_JOIN_untuk_Menggabungkan_Data\" >1. Menggunakan JOIN untuk Menggabungkan Data<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#a_INNER_JOIN\" >a. INNER JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#b_LEFT_JOIN\" >b. LEFT JOIN<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#c_RIGHT_JOIN_dan_FULL_JOIN\" >c. RIGHT JOIN dan FULL JOIN<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#2_UNION_dan_UNION_ALL\" >2. UNION dan UNION ALL<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#a_UNION\" >a. UNION<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#b_UNION_ALL\" >b. UNION ALL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#3_MERGE_Statement_Upsert\" >3. MERGE Statement (Upsert)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#Kapan_Harus_Menggunakan_Metode_yang_Mana\" >Kapan Harus Menggunakan Metode yang Mana?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#Kesimpulan\" >Kesimpulan<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Apa_Itu_Merge_Data_di_SQL\"><\/span><strong>Apa Itu Merge Data di SQL?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"683\" src=\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-1024x683.jpg\" alt=\"Cara Merge Data di SQL\" class=\"wp-image-1268\" srcset=\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-1024x683.jpg 1024w, https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-300x200.jpg 300w, https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-768x512.jpg 768w, https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-1536x1024.jpg 1536w, https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-2048x1365.jpg 2048w, https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/studio-shot-cute-brunette-girl-432x288.jpg 432w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Dalam bahasa manusia, <em>merge<\/em> di SQL itu artinya nggabungin data dari dua atau lebih tabeljadi satu, biar hasilnya bisa dilihat dalam satu tampilan yang utuh dan nyambung.Tujuan dari merge ini bisa bermacam-macam, mulai dari memperkaya data dengan informasi tambahan, menyatukan dataset dari sumber berbeda, hingga melakukan pembaruan data secara otomatis.<\/p>\n\n\n\n<p>SQL menyediakan beberapa cara untuk melakukan merge, tergantung pada kebutuhan dan struktur data yang Anda miliki. Teknik paling umum yang digunakan antara lain:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>JOIN (INNER, LEFT, RIGHT, FULL)<\/li>\n\n\n\n<li>UNION dan UNION ALL<\/li>\n\n\n\n<li>MERGE statement (khusus di SQL Server dan beberapa sistem basis data lain)<\/li>\n<\/ul>\n\n\n\n<p>Jika kamu ingin meningkatkan skill analisis data dan membuka peluang karier yang lebih luas di dunia data, mengikuti<strong><a href=\"https:\/\/kompetendigital.com\/blog\/sertifikasi-data-analyst\/\"> sertifikasi Data Analyst<\/a><\/strong> bisa jadi langkah tepat. Sertifikasi ini membuktikan kemampuanmu dalam mengolah, menganalisis, dan memvisualisasikan data secara profesional.<\/p>\n\n\n\n<p>Mari kita bahas satu per satu dengan contoh dan penjelasan yang sederhana.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1_Menggunakan_JOIN_untuk_Menggabungkan_Data\"><\/span><strong>1. Menggunakan JOIN untuk Menggabungkan Data<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>JOIN adalah metode paling umum dan fleksibel untuk menggabungkan data di SQL. Dengan JOIN, kita bisa menggabungkan dua tabel berdasarkan kolom yang memiliki relasi atau kesamaan.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"a_INNER_JOIN\"><\/span><strong>a. INNER JOIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>INNER JOIN itu cuma ngambil data yang cocok di kedua tabel. Contohnya:<\/p>\n\n\n\n<p>SELECT a.nama, b.departemen<\/p>\n\n\n\n<p>FROM karyawan a<\/p>\n\n\n\n<p>INNER JOIN departemen b<\/p>\n\n\n\n<p>ON a.id_departemen = b.id;<\/p>\n\n\n\n<p>Query ini cuma nunjukin karyawan yang departemennya cocok atau ada di daftar tabel departemen.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"b_LEFT_JOIN\"><\/span><strong>b. LEFT JOIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>LEFT JOIN itu maksudnya ngambil semua data dari tabel kiri, terus dicari kecocokannya di tabel kanan. Kalau nggak nemu yang cocok, data dari kanan dikosongin.<\/p>\n\n\n\n<p>Kalau nggak ketemu yang cocok di kanan, kolomnya dikasih nilai kosong (NULL).<\/p>\n\n\n\n<p>SELECT a.nama, b.departemen<\/p>\n\n\n\n<p>FROM karyawan a<\/p>\n\n\n\n<p>LEFT JOIN departemen b<\/p>\n\n\n\n<p>ON a.id_departemen = b.id;<\/p>\n\n\n\n<p>Cocok untuk kasus ketika Anda ingin melihat semua karyawan, termasuk yang belum punya departemen.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"c_RIGHT_JOIN_dan_FULL_JOIN\"><\/span><strong>c. RIGHT JOIN dan FULL JOIN<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>RIGHT JOIN ngambil semua data dari tabel kanan, FULL JOIN ngambil semua data dari dua tabel, baik yang cocok maupun nggak.<\/p>\n\n\n\n<p>Namun perlu dicatat, tidak semua sistem database mendukung FULL JOIN. Jika Anda menggunakan MySQL, FULL JOIN perlu disimulasikan dengan UNION dari LEFT JOIN dan RIGHT JOIN.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2_UNION_dan_UNION_ALL\"><\/span><strong>2. UNION dan UNION ALL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Berbeda dari JOIN, UNION digunakan untuk menggabungkan baris dari dua query yang memiliki struktur kolom yang sama. Artinya, UNION itu bukan nyatuin kolom, tapi <strong>numpuk hasil query satu di bawah yang lain<\/strong>, kayak nambah baris.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"a_UNION\"><\/span><strong>a. UNION<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>UNION akan menghapus baris duplikat:<\/p>\n\n\n\n<p>SELECT nama FROM pelanggan_2023<\/p>\n\n\n\n<p>UNION<\/p>\n\n\n\n<p>SELECT nama FROM pelanggan_2024;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"b_UNION_ALL\"><\/span><strong>b. UNION ALL<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>UNION ALL itu nggak buang data yang dobel, jadi prosesnya lebih cepet dijalankan.<\/p>\n\n\n\n<p>SELECT nama FROM pelanggan_2023<\/p>\n\n\n\n<p>UNION ALL<\/p>\n\n\n\n<p>SELECT nama FROM pelanggan_2024;<\/p>\n\n\n\n<p>Gunakan UNION ALL jika Anda yakin tidak masalah ada data yang sama muncul lebih dari satu kali.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3_MERGE_Statement_Upsert\"><\/span><strong>3. MERGE Statement (Upsert)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>MERGE itu fitur lanjutan yang biasanya ada di SQL Server, Oracle, dan PostgreSQL (walau cara pakainya beda-beda). MERGE sering dipakai buat <em>upsert<\/em>, yaitu ngecek dulu datanya udah ada atau belum\u2014kalau ada, di-update; kalau belum, ditambahin atau insert jika data belum ada.<\/p>\n\n\n\n<p><strong>Contoh MERGE:<\/strong><\/p>\n\n\n\n<p>MERGE INTO target t<\/p>\n\n\n\n<p>USING sumber s<\/p>\n\n\n\n<p>ON t.id = s.id<\/p>\n\n\n\n<p>WHEN MATCHED THEN<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; UPDATE SET t.nama = s.nama<\/p>\n\n\n\n<p>WHEN NOT MATCHED THEN<\/p>\n\n\n\n<p>&nbsp;&nbsp;&nbsp; INSERT (id, nama) VALUES (s.id, s.nama);<\/p>\n\n\n\n<p>Dengan MERGE, Anda tidak perlu menulis query INSERT dan UPDATE secara terpisah. Sangat berguna untuk sinkronisasi data.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kapan_Harus_Menggunakan_Metode_yang_Mana\"><\/span><strong>Kapan Harus Menggunakan Metode yang Mana?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Gunakan <strong>JOIN<\/strong> saat Anda ingin menggabungkan kolom dari dua tabel yang saling berhubungan.<\/li>\n\n\n\n<li>Gunakan <strong>UNION<\/strong> ketika Anda ingin menggabungkan hasil dari dua query yang sejenis.<\/li>\n\n\n\n<li>Pakai MERGE kalau kamu perlu <strong>ngupdate atau nambah data sekaligus<\/strong>, tergantung kondisi yang udah ditentukan.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Kesimpulan\"><\/span><strong>Kesimpulan<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Memahami cara merge data di SQL akan sangat membantu Anda dalam memanipulasi dan menganalisis data dengan lebih efektif. Mulailah dengan menguasai JOIN, lalu pahami perbedaan antara UNION dan UNION ALL, dan eksplorasi fitur MERGE jika Anda menggunakan sistem basis data yang mendukungnya.<\/p>\n\n\n\n<p>Semakin sering nyoba dan latihan, kamu bakal makin jago ngolah data pakai SQL. Selamat belajar!<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Menggabungkan atau merge data di SQL adalah keterampilan penting bagi siapa saja yang bekerja dengan basis data. Baik Anda seorang analis data, pengembang backend, atau sekadar pengguna Excel yang ingin&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1438,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"none","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","footnotes":""},"categories":[34],"tags":[187],"class_list":["post-1435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analyst","tag-cara-merge-data-di-sql","article","has-background","has-excerpt","has-avatar","has-author","has-date","has-comment-count","has-category-meta","has-read-more","has-post-media","thumbnail-"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cara Merge Data di SQL -<\/title>\n<meta name=\"description\" content=\"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Merge Data di SQL -\" \/>\n<meta property=\"og:description\" content=\"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-18T02:30:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-18T02:50:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"400\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/\",\"url\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/\",\"name\":\"Cara Merge Data di SQL -\",\"isPartOf\":{\"@id\":\"https:\/\/kompetendigital.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png\",\"datePublished\":\"2025-07-18T02:30:19+00:00\",\"dateModified\":\"2025-07-18T02:50:24+00:00\",\"author\":{\"@id\":\"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/793420f392d4b738adf327fe83e870c4\"},\"description\":\"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!\",\"breadcrumb\":{\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage\",\"url\":\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png\",\"contentUrl\":\"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png\",\"width\":600,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/kompetendigital.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara Merge Data di SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/#website\",\"url\":\"https:\/\/kompetendigital.com\/blog\/\",\"name\":\"\",\"description\":\"Jadi Profesional Setinggi Langit\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kompetendigital.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/793420f392d4b738adf327fe83e870c4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/620de75cd82a4e61ac250270ac94d652ceae998e47a5c532726a07aafe1aa197?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/620de75cd82a4e61ac250270ac94d652ceae998e47a5c532726a07aafe1aa197?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/kompetendigital.com\"],\"url\":\"https:\/\/kompetendigital.com\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cara Merge Data di SQL -","description":"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!","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:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/","og_locale":"en_US","og_type":"article","og_title":"Cara Merge Data di SQL -","og_description":"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!","og_url":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/","article_published_time":"2025-07-18T02:30:19+00:00","article_modified_time":"2025-07-18T02:50:24+00:00","og_image":[{"width":600,"height":400,"url":"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/","url":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/","name":"Cara Merge Data di SQL -","isPartOf":{"@id":"https:\/\/kompetendigital.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage"},"image":{"@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage"},"thumbnailUrl":"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png","datePublished":"2025-07-18T02:30:19+00:00","dateModified":"2025-07-18T02:50:24+00:00","author":{"@id":"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/793420f392d4b738adf327fe83e870c4"},"description":"Yuk belajar cara merge data di SQL, biar ngolah info dari banyak tabel jadi lebih gampang dan efisien!","breadcrumb":{"@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#primaryimage","url":"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png","contentUrl":"https:\/\/kompetendigital.com\/blog\/wp-content\/uploads\/2025\/07\/Tambahkan-judul-19-2.png","width":600,"height":400},{"@type":"BreadcrumbList","@id":"https:\/\/kompetendigital.com\/blog\/cara-merge-data-di-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kompetendigital.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Cara Merge Data di SQL"}]},{"@type":"WebSite","@id":"https:\/\/kompetendigital.com\/blog\/#website","url":"https:\/\/kompetendigital.com\/blog\/","name":"","description":"Jadi Profesional Setinggi Langit","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kompetendigital.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/793420f392d4b738adf327fe83e870c4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kompetendigital.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/620de75cd82a4e61ac250270ac94d652ceae998e47a5c532726a07aafe1aa197?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/620de75cd82a4e61ac250270ac94d652ceae998e47a5c532726a07aafe1aa197?s=96&d=mm&r=g","caption":"admin"},"sameAs":["https:\/\/kompetendigital.com"],"url":"https:\/\/kompetendigital.com\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/posts\/1435","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/comments?post=1435"}],"version-history":[{"count":2,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/posts\/1435\/revisions"}],"predecessor-version":[{"id":1441,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/posts\/1435\/revisions\/1441"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/media\/1438"}],"wp:attachment":[{"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/media?parent=1435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/categories?post=1435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompetendigital.com\/blog\/wp-json\/wp\/v2\/tags?post=1435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}