{"id":16848,"date":"2025-04-10T20:12:02","date_gmt":"2025-04-10T11:12:02","guid":{"rendered":"https:\/\/www.autooffice.co.kr\/?p=16848"},"modified":"2025-08-18T18:41:58","modified_gmt":"2025-08-18T09:41:58","slug":"how-to-use-full-outer-join-and-coalesce","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2025\/04\/10\/how-to-use-full-outer-join-and-coalesce\/","title":{"rendered":"FULL OUTER JOIN\uacfc COALESCE\ub97c \ud65c\uc6a9\ud574 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\uc744 \uae54\ub054\ud558\uac8c \uc870\uc778\ud558\uae30"},"content":{"rendered":"<div class=\"wp-block-aioseo-table-of-contents\"><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-1-full-outer-join\">1. \ub450 \ud14c\uc774\ube14 \uac04\uc758 FULL OUTER JOIN<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-full-outer-join\">2. \uc138 \ud14c\uc774\ube14 \uac04\uc758 FULL OUTER JOIN<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-1\">2-1. \uc774\ubbf8 \uc870\uc778\ub41c \ud14c\uc774\ube14\uc5d0 \ucd94\uac00\ub85c \uc870\uc778 \ud558\ub294 \uacbd\uc6b0<\/a><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-2-2-1-2-3\">2-2. \ucc98\uc74c\ubd80\ud130 \uc120\ud0dd\uacfc\ubaa9 1, 2, 3\uc744 \ud55c \ubc88\uc5d0 \uc870\uc778 \ud558\ub294 \uacbd\uc6b0<\/a><\/li><\/ul><\/li><li><a class=\"aioseo-toc-item\" href=\"#aioseo-3\">3. \ub8e8\ucee4\uc2a4\ud29c\ub514\uc624 \ud65c\uc6a9 \uc608\uc2dc<\/a><ul><li><a class=\"aioseo-toc-item\" href=\"#aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\">\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice\n\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/a><\/li><\/ul><\/li><\/ul><\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud574\uc11c\ub294 SQL\ubb38\ubc95\uc758 JOIN\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>INNER JOIN<\/strong><\/mark><\/code>, <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>LEFT JOIN<\/strong><\/mark><\/code>, <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code> \ub4f1 \ub2e4\uc591\ud55c JOIN \ubb38\ubc95\uc744 \ud65c\uc6a9\ud558\uba74 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \ub370\uc774\ud130\ub97c \ud558\ub098\ub85c \uacb0\ud569\ud558\uc5ec \ub354 \ud3ed\ub113\uc740 \ubd84\uc11d\uc744 \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4. SQL\ubb38\ubc95\uc758 \uaf43\uc774\ub77c\uace0\ub3c4 \ud560 \uc218 \uc788\uc9c0\uc694.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1\uc870\uc778\uc758 \uac1c\ub150\uc744 \uc54c\uace0\uc2f6\uc73c\uc2dc\ub2e4\uba74 \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0 \ub4e4\uc5b4\uac00\ubcf4\uc138\uc694.<\/p>\n\n\n\n<p><a href=\"https:\/\/data-marketing-bk.tistory.com\/entry\/SQL-JOIN-%ED%95%9C-%EB%B0%A9%EC%97%90-%EC%A0%95%EB%A6%AC-%EA%B0%9C%EB%85%90%EB%B6%80%ED%84%B0-%EC%BD%94%EB%93%9C%EA%B9%8C%EC%A7%80-%EC%9D%B4%EA%B2%83%EB%A7%8C-%EB%B3%B4%EC%9E%90\" target=\"_blank\" rel=\"noopener\" title=\"\">[SQL] JOIN \ud55c \ubc29\uc5d0 \uc815\ub9ac &#8211; \uac1c\ub150\ubd80\ud130 \ucf54\ub4dc\uae4c\uc9c0 \uc774\uac83\ub9cc \ubcf4\uc790<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong>\uc774\ubc88 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 JOIN \uc911\uc5d0\uc11c\ub3c4 FULL OUTER JOIN \uc744 \uc0b4\ud3b4\ubcf4\uba70, COALESCE \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc54c\uc544\ubd05\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n<p><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code> \uc740 \ub450 \uac1c\uc758 \ud14c\uc774\ube14\uc744 \uacb0\ud569\ud560 \ub54c \uc591\ucabd \ud14c\uc774\ube14\uc758 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud558\uc9c0\ub9cc, \uc870\uc778 \uc870\uac74\uc5d0 \uc77c\uce58\ud558\uc9c0 \uc54a\ub294 \uac12\uc740 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code> <\/strong>\ub85c \ud45c\uc2dc\ud558\ub294 \ud2b9\uc9d5\uc774 \uc788\uc2b5\ub2c8\ub2e4. \uc22b\uc790 \uac12\uc758 \uacbd\uc6b0\uc5d0\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code> <\/strong>\ub85c \ud45c\uc2dc\ud574\ub3c4 \ubb34\ubc29\ud558\uc9c0\ub9cc, \uc870\uc778 \uc870\uac74\uc5d0 \ub4e4\uc5b4\uc788\ub294 \ud14d\uc2a4\ud2b8\uc758 \uacbd\uc6b0\uc5d0\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code> <\/strong>\uc774 \uc544\ub2cc \uac12\uc73c\ub85c \ud569\uccd0\uc11c \ubcf4\uc5ec\uc8fc\ub294 \uac83\uc774 \ud544\uc694\ud560 \ub54c\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub7f0 \uacbd\uc6b0, <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code> \uacfc \ud568\uaed8 \uc0ac\uc6a9\ud574\uc11c \ud574\uacb0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc774 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 \uc608\uc81c\ub97c \ud1b5\ud574 <code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code> \uacfc <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\uc758 \uac1c\ub150\uc744 \uc0b4\ud3b4\ubcf4\uace0, \ub450 \uad6c\ubb38\uc744 \ud568\uaed8 \uc0ac\uc6a9\ud558\uc5ec <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code> <\/strong>\uc744 \ud6a8\uacfc\uc801\uc73c\ub85c \ucc98\ub9ac\ud558\ub294 \ubc29\ubc95\uc744 \uc54c\uc544\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-1-full-outer-join\"><strong>1. \ub450 \ud14c\uc774\ube14 \uac04\uc758 FULL OUTER JOIN<\/strong><\/h2>\n\n\n\n<p><br><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code> \uc740 \uc27d\uac8c \ub9d0\ud574 \ub450 \ud14c\uc774\ube14\uc5d0 \uc874\uc7ac\ud558\ub294 \ubaa8\ub4e0 \ub370\uc774\ud130\ub97c \ud3ec\ud568\ud558\ub294 \uc870\uc778 \ubc29\uc2dd\uc785\ub2c8\ub2e4. A\ud14c\uc774\ube14\uacfc B\ud14c\uc774\ube14\uc744 \uc870\uc778\ud55c\ub2e4\uace0 \ud560 \ub54c (1) A\ud14c\uc774\ube14\uc5d0\ub9cc \uc788\ub294 \ub370\uc774\ud130 (2) B\ud14c\uc774\ube14\uc5d0\ub9cc \uc788\ub294 \ub370\uc774\ud130 (3) A\uc640 B \ud14c\uc774\ube14 \ub458 \ub2e4 \uc788\ub294 \ub370\uc774\ud130\ub97c \ubaa8\ub450 \ud3ec\ud568\ud569\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code> \ubb38\ubc95\uc5d0 \ub300\ud574\uc11c \uc790\uc138\ud788 \uc54c\uc544\ubcf4\ub824\uba74 \uc544\ub798\uc758 \ub808\ud37c\ub7f0\uc2a4\uc5d0 \uc811\uc18d\ud574\ubcf4\uc138\uc694.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"alignleft size-full is-resized\"><a href=\"https:\/\/www.w3schools.com\/sql\/sql_join_full.asp\" target=\"_blank\" rel=\" noreferrer noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"281\" height=\"281\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/77673807.png\" alt=\"\" class=\"wp-image-16850\" style=\"width:210px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/77673807.png 281w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/77673807-150x150.png 150w\" sizes=\"auto, (max-width: 281px) 100vw, 281px\" \/><\/a><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/www.w3schools.com\/sql\/sql_join_full.asp\" target=\"_blank\" rel=\"noopener\" title=\"w3chools \ubc14\ub85c\uac00\uae30\">SQL FULL OUTER JOIN Keyword<\/a><\/figcaption><\/figure>\n<\/div>\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n\n\n\n<p>\u3000\u3000<\/p>\n\n\n\n<p>\u3000\u3000<\/p>\n\n\n\n<p>\u3000<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p><strong>\uc774\uc81c \uc608\ub97c \ub4e4\uc5b4, \ud55c \ubc18\uc758 \ud559\uc0dd\ub4e4\uc774 \uc120\ud0dd \uacfc\ubaa9 2\uac1c\uc758 \uc2dc\ud5d8\uc744 \ubd24\ub2e4\uace0 \uc0dd\uac01\ud574\ubd05\uc2dc\ub2e4.<\/strong><\/p>\n\n\n\n<p>\uc120\ud0dd\uacfc\ubaa9 1\ubc88\uc744 \ubcf8 \ud559\uc0dd\uc740 \ucca0\uc218, \uc601\ud76c, \ubbfc\uc218\uc774\uace0, \uc120\ud0dd\uacfc\ubaa9 2\ubc88\uc744 \ubcf8 \ud559\uc0dd\uc740 \uc601\ud76c, \ubbfc\uc9c0, \uc900\ud638\ub77c\uace0 \ud569\uc2dc\ub2e4. \ucd1d 5\uba85\uc758 \ud559\uc0dd\uc758 \uc2dc\ud5d8 \uc810\uc218\ub97c \ud55c \ud14c\uc774\ube14\ub85c \ud569\uccd0\uc57c \ud55c\ub2e4\uba74 <code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code> \uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"848\" height=\"239\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image0.png\" alt=\"\" class=\"wp-image-16851\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image0.png 848w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image0-300x85.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image0-768x216.png 768w\" sizes=\"auto, (max-width: 848px) 100vw, 848px\" \/><\/figure>\n\n\n\n<p><br>\uc774\ub984\uc744 \uc870\uc778\uc758 \ud0a4 \uceec\ub7fc\uc73c\ub85c \uc0ac\uc6a9\ud574\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \ucffc\ub9ac\ub97c \uc791\uc131\ud558\uba74 \ud55c \ud14c\uc774\ube14\ub85c \ud569\uccd0\uc11c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc870\uc778 \ud0a4\uc758 \uac12\uc774 \uc5c6\uc73c\uba74 \ud56d\ubaa9\ub4e4\uc740 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong> \ub85c \uc785\ub825\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n    A.\uc774\ub984,  \n    B.\uc774\ub984,  \n    A.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa91\uc810\uc218,  \n    B.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa92\uc810\uc218  \nFROM \uc120\ud0dd\uacfc\ubaa91\uc2dc\ud5d8 A  \nFULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa92\uc2dc\ud5d8 B  \nON A.\uc774\ub984 = B.\uc774\ub984;\n<\/code><\/pre>\n\n\n\n<p><br>\uc544\ub798\uc758 \uacb0\uacfc\uc5d0\uc11c \uc54c \uc218 \uc788\ub294 \uac83\ucc98\ub7fc, \uc120\ud0dd\uacfc\ubaa91\uc2dc\ud5d8\uc5d0\ub294 \uc788\uc9c0\ub9cc \uc120\ud0dd\uacfc\ubaa92\uc2dc\ud5d8\uc5d0\ub294 \uc5c6\ub294 \ucca0\uc218\uc640 \ubbfc\uc218\ub294 B.\uc774\ub984\uacfc \uc120\ud0dd\uacfc\ubaa92\uc810\uc218\uac00 \ubaa8\ub450 <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code> \ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"846\" height=\"358\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1.png\" alt=\"\" class=\"wp-image-16852\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1.png 846w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1-300x127.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-1-1-768x325.png 768w\" sizes=\"auto, (max-width: 846px) 100vw, 846px\" \/><\/figure>\n\n\n\n<p><br>\ud55c \ub208\uc5d0 \uc774\ud574\ud558\ub824\uba74, A.\uc774\ub984, B.\uc774\ub984\uc744 \ud569\uccd0\uc11c \ud55c \uceec\ub7fc\uc73c\ub85c \ubcf4\ub294 \uac83\uc774 \uc88b\uaca0\uc9c0\uc694? \uc774\ub7f4 \ub54c, <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong><\/code>\ub294 \ub450 \uceec\ub7fc\uc744 \ud558\ub098\ub85c \ud1b5\ud569\ud558\ub294 \uacb0\uacfc\ub97c \uac00\uc838\uc624\ub294\ub370, \ub2e4\uc74c\uacfc \uac19\uc774 \ucffc\ub9ac\ub97c \uc368\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ud568\uc218\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc774 \uc544\ub2cc \uccab \ubc88\uc9f8 \uac12\uc744 \ubc18\ud658\ud558\ub294 \ud568\uc218\uc785\ub2c8\ub2e4. \uae30\ubcf8 \ubb38\ubc95\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. \uc67c\ucabd\ubd80\ud130 \ucc28\ub840\ub85c \uac12\uc744 \uac80\uc0ac\ud574\uc11c <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc774 \uc544\ub2cc \uccab \ubc88\uc9f8 \uac12\uc744 \ubc18\ud658\ud558\ub294 \ubc29\uc2dd\uc774\uc9c0\uc694. \ub9cc\uc57d \ubaa8\ub4e0 \uac12\uc774 <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code>\uc774\ub77c\uba74 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>COALESCE(\uac121, \uac122, \uac123, &#8230;)<\/strong><br><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n    COALESCE(A.\uc774\ub984, B.\uc774\ub984) AS \uc774\ub984,\n    A.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa91\uc810\uc218,\n    B.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa92\uc810\uc218\nFROM \uc120\ud0dd\uacfc\ubaa91\uc2dc\ud5d8 A\nFULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa92\uc2dc\ud5d8 B \nON A.\uc774\ub984 = B.\uc774\ub984;<\/code><\/pre>\n\n\n\n<p><br>\uccab \ubc88\uc9f8 \ud589\uc5d0\uc11c A.\uc774\ub984\uc740 \ucca0\uc218\uc774\uace0, B.\uc774\ub984\uc740 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc774\uae30 \ub54c\ubb38\uc5d0 \ucca0\uc218\ub85c \ud45c\uc2dc\ub418\uace0, 4\ubc88\uc9f8 \ud589\uc5d0\uc11c A.\uc774\ub984\uc740 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc774\uace0 B.\uc774\ub984\uc740 \ubbfc\uc9c0\uc774\uae30\uc5d0 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong>\uc774 \uc544\ub2cc \ubbfc\uc9c0\ub85c \ud45c\uc2dc \ub429\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"668\" height=\"354\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1.png\" alt=\"\" class=\"wp-image-16853\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1.png 668w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-2-1-300x159.png 300w\" sizes=\"auto, (max-width: 668px) 100vw, 668px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\u26a0\ufe0f\ube45\ucffc\ub9ac\uc6a9 \ud14c\uc2a4\ud2b8 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud574\uc11c \uc9c1\uc811 \uc2e4\ud589\ud574\ubcf4\uc138\uc694.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH CTE1 AS (\n  SELECT '\ucca0\uc218' AS name, 100 AS score\n  UNION ALL\n  SELECT '\uc601\ud76c', 90\n  UNION ALL\n  SELECT '\ubbfc\uc218', 80\n),\nCTE2 AS (\n  SELECT '\uc601\ud76c' AS name, 100 AS score\n  UNION ALL\n  SELECT '\ubbfc\uc9c0', 90\n  UNION ALL\n  SELECT '\uc900\ud638', 80\n)\n\nSELECT \n    A.name as nameA,  \n    B.name as nameB,  \n    coalesce(A.name, B.name) as name,\n    A.score AS score1,  \n    B.score AS score2  \nFROM CTE1 A  \nFULL OUTER JOIN CTE2 B  \nON A.name = B.name;<\/code><\/pre>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-2-full-outer-join\"><br><strong>2. \uc138 \ud14c\uc774\ube14 \uac04\uc758 FULL OUTER JOIN<\/strong><\/h1>\n\n\n\n<p><br>\uc5ec\uae30\uc11c \uc120\ud0dd\uacfc\ubaa93\uc5d0 \ub300\ud55c \uc810\uc218\ub3c4 \ub2e4\uc74c\uacfc \uac19\uc774 \uc788\ub2e4\uace0 \ub354 \uc0dd\uac01\ud574\ubd05\uc2dc\ub2e4. \uc774 \ud14c\uc774\ube14\ub3c4 \uacb0\uacfc\uc5d0 \ub123\uace0 \uc2f6\ub2e4\uba74 \uc5b4\ub5bb\uac8c \ud560 \uc218 \uc788\uc744\uae4c\uc694?<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"545\" height=\"306\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3-1.png\" alt=\"\" class=\"wp-image-16854\" style=\"width:439px;height:auto\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3-1.png 545w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-3-1-300x168.png 300w\" sizes=\"auto, (max-width: 545px) 100vw, 545px\" \/><\/figure>\n<\/div>\n\n\n<p><br><strong>2\uac00\uc9c0 \ubc29\ubc95\uc774 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\uc774\ubbf8 \uc870\uc778\ub41c \uc120\ud0dd\uacfc\ubaa91&amp;2 \ud14c\uc774\ube14\uc5d0 \ud55c \ubc88 \ub354 \uc870\uc778<\/li>\n\n\n\n<li>\ucc98\uc74c\ubd80\ud130 \uc120\ud0dd\uacfc\ubaa91, 2, 3\uc744 \ud55c \ubc88\uc5d0 \uc870\uc778<br><br><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-1\"><strong>2-1. \uc774\ubbf8 \uc870\uc778\ub41c \ud14c\uc774\ube14\uc5d0 \ucd94\uac00\ub85c \uc870\uc778 \ud558\ub294 \uacbd\uc6b0<\/strong><\/h2>\n\n\n\n<p><br><strong>\uc774\ubbf8 \uc870\uc778\ub41c \ud14c\uc774\ube14\uc744 CTE\ub85c \uc124\uc815\ud558\uace0, \uc870\uc778\uc744 \ud55c \ubc88 \ub354 \ud569\ub2c8\ub2e4.<\/strong><br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\ud83d\udca1<strong>CTE\ub780?<\/strong> CTE(Common Table Expression)\ub294 SQL\uc5d0\uc11c \uc784\uc2dc\ub85c \uc0dd\uc131\ud558\ub294 \ud14c\uc774\ube14\uc785\ub2c8\ub2e4. \uc774\uac83\uc740 \ucffc\ub9ac\uc758 \uac00\ub3c5\uc131\uc744 \ub192\uc774\uace0 \uc7ac\uc0ac\uc6a9\uc131\uc744 \ud5a5\uc0c1\uc2dc\ud0a4\ub294 \uc5ed\ud560\uc744 \ud569\ub2c8\ub2e4. WITH\ubb38\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc815\uc758\ud569\ub2c8\ub2e4. \uc608\uc2dc\uc5d0\uc11c\ub294 \uac01 \uae30\uac04 \ubcc4\ub85c SELECT\ud558\ub294 \uad6c\ubb38\uc774 \uad04\ud638\ub85c \ubb36\uc5ec\uc788\ub294\ub370, \uc774 \ub2e8\uc704\ub4e4\uc744 CTE\ub77c\uace0 \ud569\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH CTE AS (\n  SELECT \n    COALESCE(A.\uc774\ub984, B.\uc774\ub984) AS \uc774\ub984,\n    A.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa91\uc810\uc218,\n    B.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa92\uc810\uc218\n  FROM \uc120\ud0dd\uacfc\ubaa91\uc2dc\ud5d8 A\n  FULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa92\uc2dc\ud5d8 B \n  ON A.\uc774\ub984 = B.\uc774\ub984\n  )\n\t\n  SELECT\n    COALESCE(M.\uc774\ub984, C.\uc774\ub984) AS \uc774\ub984,\n    M.\uc120\ud0dd\uacfc\ubaa91\uc810\uc218,\n    M.\uc120\ud0dd\uacfc\ubaa92\uc810\uc218,\n    D.\uc120\ud0dd\uacfc\ubaa93\uc810\uc218 \n  FROM CTE M \n  FULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa93\uc2dc\ud5d8 C\n  ON M.\uc774\ub984 = C.\uc774\ub984<\/code><\/pre>\n\n\n\n<p><br>\ub2e4\uc74c\uacfc \uac19\uc740 \ud1b5\ud569\ub41c \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"462\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-1-1024x462.png\" alt=\"\" class=\"wp-image-16855\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-1-1024x462.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-1-300x135.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-1-768x346.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-4-1.png 1279w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\u26a0\ufe0f&nbsp;\ube45\ucffc\ub9ac\uc6a9 \ud14c\uc2a4\ud2b8 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud574\uc11c \uc9c1\uc811 \uc2e4\ud589\ud574\ubcf4\uc138\uc694.<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH CTE1 AS (\n  SELECT '\ucca0\uc218' AS name, 100 AS score\n  UNION ALL\n  SELECT '\uc601\ud76c', 90\n  UNION ALL\n  SELECT '\ubbfc\uc218', 80\n),\nCTE2 AS (\n  SELECT '\uc601\ud76c' AS name, 100 AS score\n  UNION ALL\n  SELECT '\ubbfc\uc9c0', 90\n  UNION ALL\n  SELECT '\uc900\ud638', 80\n),\nCTE3 AS (\n  SELECT \n    A.name as nameA,  \n    B.name as nameB,  \n    coalesce(A.name, B.name) as name,\n    A.score AS score1,  \n    B.score AS score2  \n  FROM CTE1 A  \n  FULL OUTER JOIN CTE2 B  \n  ON A.name = B.name\n),\nCTE4 AS (\n  SELECT '\ud76c\uc6d0' AS name, 50 AS score\n  UNION ALL\n  SELECT '\uc601\ud76c', 70\n  UNION ALL\n  SELECT '\uc900\ud638', 30\n)\n\nSELECT \n    M.name as nameM,  \n    C.name as nameC,  \n    coalesce(M.name, C.name) as name,\n    M.score1 AS score1,  \n    M.score2 AS score2,\n    C.score AS score3  \nFROM CTE3 M  \nFULL OUTER JOIN CTE4 C  \nON M.name = C.name;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-2-2-1-2-3\"><br><strong>2-2. \ucc98\uc74c\ubd80\ud130 \uc120\ud0dd\uacfc\ubaa9 1, 2, 3\uc744 \ud55c \ubc88\uc5d0 \uc870\uc778 \ud558\ub294 \uacbd\uc6b0<\/strong><\/h2>\n\n\n\n<p><br>CTE\ub97c \ub9cc\ub4e4\uc9c0 \uc54a\uace0, \ud55c \ubc88\uc5d0 \uc138 \ud14c\uc774\ube14\uc744 \uc870\uc778\ud569\ub2c8\ub2e4. \ubb3c\ub860 \uc870\uc778\uc740 \uc21c\ucc28\uc801\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9d1\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub450\ubc88\uc9f8 \uc870\uc778 \uc870\uac74\uc5d0\uc11c <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uc0ac\uc6a9\ud574\uc11c 1\ubc88\uacfc \ub3d9\uc77c\ud55c \uacb0\uacfc\ub97c \uc5bb\uc744 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucf54\ub4dc\uac00 \ud6e8\uc52c \uac04\uacb0\ud574\uc838\uc11c \ubcf4\uae30 \uc88b\uc9c0\uc694?<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT \n    COALESCE(A.\uc774\ub984, B.\uc774\ub984, C.\uc774\ub984) AS \uc774\ub984,\n    A.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa91\uc810\uc218,\n    B.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa92\uc810\uc218,\n    C.\uc810\uc218 AS \uc120\ud0dd\uacfc\ubaa93\uc810\uc218\nFROM \uc120\ud0dd\uacfc\ubaa91\uc2dc\ud5d8 A\nFULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa92\uc2dc\ud5d8 B \nON A.\uc774\ub984 = B.\uc774\ub984\nFULL OUTER JOIN \uc120\ud0dd\uacfc\ubaa93\uc2dc\ud5d8 C \nON COALESCE(A.\uc774\ub984, B.\uc774\ub984) = C\uc774\ub984\n<\/code><\/pre>\n\n\n\n<p><br>\u26a0\ufe0f&nbsp;\ube45\ucffc\ub9ac\uc6a9 \ud14c\uc2a4\ud2b8 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud574\uc11c \uc9c1\uc811 \uc2e4\ud589\ud574\ubcf4\uc138\uc694.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>WITH CTE1 AS (\n  SELECT '\ucca0\uc218' AS name, 100 AS score\n  UNION ALL\n  SELECT '\uc601\ud76c', 90\n  UNION ALL\n  SELECT '\ubbfc\uc218', 80\n),\nCTE2 AS (\n  SELECT '\uc601\ud76c' AS name, 100 AS score\n  UNION ALL\n  SELECT '\ubbfc\uc9c0', 90\n  UNION ALL\n  SELECT '\uc900\ud638', 80\n),\nCTE4 AS (\n  SELECT '\ud76c\uc6d0' AS name, 50 AS score\n  UNION ALL\n  SELECT '\uc601\ud76c', 70\n  UNION ALL\n  SELECT '\uc900\ud638', 30\n)\n\nSELECT \n    A.name as nameA,  \n    B.name as nameB,      \n    coalesce(A.name, B.name) as nameM,   \n    C.name as nameC,  \n    coalesce(A.name, B.name, C.name) as name,\n    A.score AS score1,  \n    B.score AS score2,\n    C.score AS score3  \nFROM CTE1 A  \nFULL OUTER JOIN CTE2 B  \nON A.name = B.name\nFULL OUTER JOIN CTE4 C  \nON COALESCE(A.name, B.name) = C.name;\n<\/code><\/pre>\n\n\n\n<p><br><strong>\ub9cc\uc57d \ub450 \ubc88\uc9f8 \uc870\uc778 \uc870\uac74\uc5d0\uc11c <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uc4f0\uc9c0 \uc54a\uace0 <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">ON A.name = C.name<\/mark><\/code> \uc73c\ub85c \ud558\uba74 \uc5b4\ub5a4 \uc77c\uc774 \ubc8c\uc5b4\uc9c8\uae4c\uc694?<\/strong><\/p>\n\n\n\n<p>\uccab\ubc88\uc9f8 \uc2dc\ud5d8 \ud14c\uc774\ube14\uc5d0 \uc5c6\uc9c0\ub9cc 2, 3\ubc88\uc9f8 \uc2dc\ud5d8\ud14c\uc774\ube14\uc5d0 \uc788\ub294 \uc900\ud638\uac00 \uc62c\ubc14\ub974\uac8c \uc870\uc778\ub418\uc9c0 \uc54a\uc544\uc11c \ub2e4\uc74c\uacfc \uac19\uc774 \uacb0\uacfc\uac00 \ub098\uc635\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uc900\ud638\uc758 2, 3\ubc88\uc9f8 \uc2dc\ud5d8\uc774 \uc870\uc778\ub418\uc9c0 \uc54a\uc544\uc11c \uac1c\ubcc4\uc801\uc778 \ud589\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc774\uac74 \uc6b0\ub9ac\uac00 \uc6d0\ud558\ub294 \uac83\uc774 \uc544\ub2c8\uc9c0\uc694.<\/strong><br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"529\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1-1024x529.png\" alt=\"\" class=\"wp-image-16856\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1-1024x529.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1-300x155.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1-768x397.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-5-1.png 1107w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<p><br>\uc774 \uc608\uc81c\ub97c \ud1b5\ud574 <code><code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code><\/code> \uc73c\ub85c \uc5ec\ub7ec \ud14c\uc774\ube14\uc744 \ud55c \ubc88\uc5d0 \uc870\uc778\ud560 \ub54c\uc5d0\ub294 \uc870\uc778 \uc870\uac74\uc5d0 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uc368\uc57c \ud55c\ub2e4\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. <code><code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code><\/code> \uacfc <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\uc5d0 \ub300\ud55c \uae30\ubcf8 \uc9c0\uc2dd\uc744 \uc18c\uac1c\ud558\uc600\uc73c\ub2c8 \uc774\uc81c \uc2e4\uc81c \uc0ac\uc6a9 \uc0ac\ub840\ub97c \uc18c\uac1c\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"aioseo-3\">3. \ub8e8\ucee4\uc2a4\ud29c\ub514\uc624 \ud65c\uc6a9 \uc608\uc2dc<\/h1>\n\n\n\n<p><br>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\ub294 \uae30\uac04 \ubcc4\ub85c \ub2e4\uc591\ud55c \uc218\uce58\ub97c \ube44\uad50\ud558\ub294 \uae30\ub2a5\uc774 \ub0b4\uc7ac\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \uadf8 \uc911\uc5d0 \u2018<strong>\ub9de\ucda4 \ucffc\ub9ac<\/strong>\u2019 \ub610\ub294 \u2018<strong>\ucee4\uc2a4\ud140 \ucffc\ub9ac<\/strong>\u2019 \ub77c\uace0 \ud558\ub294 \uae30\ub2a5\uc740 SQL\ubb38\uc744 \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc791\uc131\ud558\uace0 \ube45\ucffc\ub9ac\ub85c \ubcf4\ub0b4\uc5b4 \uc2e4\ud589\ud55c \uacb0\uacfc\ub97c \ubc1b\uc544\uc624\ub294 \uae30\ub2a5\uc774\uc9c0\uc694.<br><br><\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p> \ud83d\udca1\uc9c0\uae08\ubd80\ud130 \ub2e4\ub8f0 \ub0b4\uc6a9\uc740 \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \ub2e4\ub8e8\ub294 \ub0b4\uc6a9\uc5d0 \ub300\ud574 \uc18c\uac1c\ub418\ub294 \uac83\uc73c\ub85c, \uc544\ub798\uc758 \ud3ec\uc2a4\ud2b8\ub97c \uc77d\uc5b4\ubcf4\uc9c0 \uc54a\uc558\ub2e4\uba74 \ub9c1\ud06c\ub97c \ucc38\uc870\ud574\uc8fc\uc138\uc694.<\/p>\n\n\n\n<p><a href=\"https:\/\/www.autooffice.co.kr\/blog\/2025\/04\/10\/how-to-use-custom-queries-using-parameters\/\" target=\"_blank\" rel=\"noopener\" title=\"\">\ub9de\ucda4 \ucffc\ub9ac(\ucee4\uc2a4\ud140 \ucffc\ub9ac) \ud65c\uc6a9\ud558\uae30 \u2013 \uae30\uac04 \ub9e4\uac1c\ubcc0\uc218<\/a><\/p>\n<\/blockquote>\n\n\n\n<p><br><\/p>\n\n\n\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc544\ub798\uc640 \uac19\uc774 \uc77c\uc790\ubcc4 \ub9e4\ucd9c\uc774 \ub2f4\uae34 \ud14c\uc774\ube14\uc774 \uc788\uc744 \ub54c, <code><code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code><\/code> \uacfc <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\uc744 \uc0ac\uc6a9\ud558\uba74 \ud574\ub2f9 \uae30\uac04\uc758 1\ub144 \uc804, 1\uac1c\uc6d4 \uc804, 2\uac1c\uc6d4 \uc804, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\ub3c4 \ud55c\uaebc\ubc88\uc5d0 \ud1b5\ud569\ud574\uc11c \ubcf4\uc5ec\uc904 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"429\" height=\"266\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1.png\" alt=\"\" class=\"wp-image-16857\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1.png 429w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-6-1-300x186.png 300w\" sizes=\"auto, (max-width: 429px) 100vw, 429px\" \/><figcaption class=\"wp-element-caption\">\uc608\uc81c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ud14c\uc774\ube14\uc758 \uc774\ub984\uc740 \u2018LS_salesData\u2019 \uc785\ub2c8\ub2e4.<\/figcaption><\/figure>\n<\/div>\n\n\n<p><br><\/p>\n\n\n\n<p>\ucc38\uc870 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc0ac\uc6a9\ud588\ub358 \ucffc\ub9ac\ub97c \ub2e4\uc2dc \ud55c\ubc88 \uc0b4\ud3b4\ubcfc\uae4c\uc694? \ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624\uc5d0\uc11c \uc2dc\uc791 \ub0a0\uc9dc(<code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>@DS_START_DATE<\/strong><\/mark><\/code>)\uc640 \uc885\ub8cc \ub0a0\uc9dc(<code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>@DS_END_DATE<\/strong><\/mark><\/code>) \ub9e4\uac1c\ubcc0\uc218\ub97c \ubc1b\uace0 \uc788\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- \uc120\ud0dd \uae30\uac04\uc758 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nWITH currentData AS (\n    SELECT salesDate, SUM(revenue) AS currentRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN PARSE_DATE('%Y%m%d', @DS_START_DATE) AND PARSE_DATE('%Y%m%d', @DS_END_DATE)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 1\ub144 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nlastYearData  AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 YEAR) AS salesDate, SUM(revenue) AS lastYearRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 YEAR) AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 YEAR)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30 \noneMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 1 MONTH) AS salesDate, SUM(revenue) AS oneMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 1 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 1 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\ntwoMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 2 MONTH) AS salesDate, SUM(revenue) AS twoMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 2 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 2 MONTH)\n    GROUP BY salesDate\n),\n-- \uc120\ud0dd \uae30\uac04\uc758 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c \uc77c\uc790\ubcc4\ub85c \ubd88\ub7ec\uc624\uae30\nthreeMonthAgoData AS (\n    SELECT DATE_ADD(salesDate, INTERVAL 3 MONTH) AS salesDate, SUM(revenue) AS threeMonthAgoRevenue\n    FROM autoofficeshare.commerce_sample.LS_salesData\n    WHERE salesDate BETWEEN DATE_SUB(PARSE_DATE('%Y%m%d', @DS_START_DATE), INTERVAL 3 MONTH) \n    AND DATE_SUB(PARSE_DATE('%Y%m%d', @DS_END_DATE), INTERVAL 3 MONTH)\n    GROUP BY salesDate\n)\n-- \uc804\uccb4 \uae30\uac04 \ub370\uc774\ud130 \ud1b5\ud569\ud558\uae30\nSELECT \n    COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate, m3.salesDate) AS salesDate,\n    COALESCE(c.currentRevenue, 0) AS currentRevenue,\n    COALESCE(l.lastYearRevenue, 0) AS lastYearRevenue,\n    COALESCE(m1.oneMonthAgoRevenue, 0) AS oneMonthAgoRevenue,\n    COALESCE(m2.twoMonthAgoRevenue, 0) AS twoMonthAgoRevenue,\n    COALESCE(m3.threeMonthAgoRevenue, 0) AS threeMonthAgoRevenue\nFROM currentData c\nFULL OUTER JOIN lastYearData l \n    ON c.salesDate = l.salesDate\nFULL OUTER JOIN oneMonthAgoData m1 \n    ON COALESCE(c.salesDate, l.salesDate) = m1.salesDate \nFULL OUTER JOIN twoMonthAgoData m2 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate) = m2.salesDate \nFULL OUTER JOIN threeMonthAgoData m3 \n    ON COALESCE(c.salesDate, l.salesDate, m1.salesDate, m2.salesDate) = m3.salesDate \nORDER BY salesDate;\n<\/code><\/pre>\n\n\n\n<p><br>\ucffc\ub9ac\uc758 \uacb0\uacfc \ud654\uba74\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 \ub0a0\uc9dc\uc5d0 \ub300\ud574\uc11c \ube44\uad50 \uae30\uac04 \ubcc4\ub85c \ub9e4\ucd9c\uc744 \ud55c \ub208\uc5d0 \ud30c\uc545\ud560 \uc218 \uc788\ub3c4\ub85d \ud1b5\ud569\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc5b4\ub5bb\uac8c \uc774\ub7f0 \uacb0\uacfc\uac00 \ub098\uc62c \uc218 \uc788\uc5c8\uc744\uae4c\uc694?<\/p>\n\n\n\n<p>\uc608\uc81c\uc5d0\uc11c \uc0b4\ud3b4\ubcf8 &#8216;<strong>2-2 \ucc98\uc74c\ubd80\ud130 \uc120\ud0dd\uacfc\ubaa9 1, 2, 3\uc744 \ud55c \ubc88\uc5d0 \uc870\uc778 \ud558\ub294 \uacbd\uc6b0<\/strong>&#8216;\uc758 \ubc29\ubc95\uc744 \uc0ac\uc6a9\ud55c \uacb0\uacfc\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\uc120\ud0dd \uae30\uac04 \ub9e4\ucd9c CTE, 1\ub144 \uc804 \ub9e4\ucd9c CTE, 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c CTE, 2\uac1c\uc6d4 \uc804 \ub9e4\ucd9c CTE, 3\uac1c\uc6d4 \uc804 \ub9e4\ucd9c CTE\ub97c \uac01\uac01 \uc0dd\uc131\ud55c \ub4a4\uc5d0 CTE\ub4e4\uc744 \uc77c\uc790 \uae30\uc900\uc73c\ub85c \ud55c \ubc88\uc5d0 <code><code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code><\/code> \ud558\uc600\uc2b5\ub2c8\ub2e4. \uc608\uc81c\uc5d0\uc11c \uc0b4\ud3b4\ubcf8 \uac83\ucc98\ub7fc, \ud55c \ubc88\uc5d0 \uc5ec\ub7ec \ud14c\uc774\ube14\uc744 \uc870\uc778\ud558\uba74\uc11c salesDate\uc5d0\uc11c <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code>\uc774 \uc5c6\ub3c4\ub85d \ud1b5\ud569\ud558\uae30 \uc704\ud574\uc11c SELECT \uc640 \uc870\uc778 \uc870\uac74\uc5d0 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uc0ac\uc6a9\ud558\uc600\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"335\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1-1024x335.png\" alt=\"\" class=\"wp-image-16858\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1-1024x335.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1-300x98.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1-768x251.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-7-1.png 1268w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\ucc98\uc74c \uc138 \ud14c\uc774\ube14 \uac04\uc758 \uc870\uc778\uc744 \ub3c4\uc2dd\ud654 \ud558\uba74 \ub2e4\uc74c\uc758 \uc774\ubbf8\uc9c0\uc640 \uac19\uc2b5\ub2c8\ub2e4.<br><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"506\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1-1024x506.png\" alt=\"\" class=\"wp-image-16859\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1-1024x506.png 1024w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1-300x148.png 300w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1-768x379.png 768w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-8-1.png 1162w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><br>\uc870\uc778 \uc870\uac74\uc5d0\uc11c <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\uad6c\ubb38\uc744 \uc0ac\uc6a9\ud588\uae30 \ub54c\ubb38\uc5d0 JOIN \ud560 \ub54c \ub204\ub77d\ub418\ub294 \uac12 \uc5c6\uc774 JOIN\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uac01\uac01\uc758 JOIN \ub2e8\uacc4\uc5d0\uc11c \uc77c\uce58\ud558\ub294 \uc77c\uc790\uac00 \uc5c6\uc744 \ub54c\uc5d0, \ub2e4\uc74c CTE\uc758 \uc77c\uc790\uc640 \ub300\uc870\ud558\ub294 \ubc29\uc2dd\uc774\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p><strong>\uccab \ubc88\uc9f8 JOIN<\/strong>\uc5d0\uc11c \uc120\ud0dd \uae30\uac04\uc758 \uc77c\ubcc4 \ub9e4\ucd9c CTE\uc5d0\ub294 1\ub144\uc804 \uc77c\ubcc4 \ub9e4\ucd9c CTE\uc5d0 \uc788\ub294 \u20182025-01-02\u2019\uac00 \uc5c6\uc2b5\ub2c8\ub2e4. \uc77c\uc790\uc5d0\ub294 <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\uac00 \uc801\uc6a9\ub418\uc5c8\uae30 \ub54c\ubb38\uc5d0 \u20182025-01-02\u2019\uac00 \ud45c\uc2dc\ub418\uc9c0\ub9cc, \uc120\ud0dd\uae30\uac04 \uc77c\ubcc4 \ub9e4\ucd9c\uc5d0\ub294 <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code>\uc774 \uc0bd\uc785\ub429\ub2c8\ub2e4. (\uc774 \ubd80\ubd84\ub3c4 <code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>COALESCE(c.currentRevenue, 0)<\/strong><\/mark><\/code> \uc744 \uc801\uc6a9\ud574\uc11c <code><strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">NULL<\/mark><\/code><\/strong><\/code>\ub300\uc2e0 0\uc73c\ub85c \ud45c\uc2dc\ub418\ub3c4\ub85d \ub9cc\ub4ed\ub2c8\ub2e4.)<\/p>\n\n\n\n<p><strong>\ub450 \ubc88\uc9f8 JOIN<\/strong>\uc5d0\uc11c \uc120\ud0dd\uae30\uac04\uc758 \uc77c\ubcc4 \ub9e4\ucd9c\uacfc 1\uac1c\uc6d4\uc804 \uc77c\ubcc4 \ub9e4\ucd9c\uc744 \uc870\uc778\ud558\ub824\uace0 \ud558\ub294\ub370, \uc120\ud0dd\uae30\uac04\uc758 \uc77c\ubcc4 \ub9e4\ucd9c\uc5d0\ub294 \u20182025-01-02\u2019\uc640 \uc77c\uce58\ud558\ub294 \ud589\uc774 \uc5c6\uc9c0\uc694, \uadf8\ub798\uc11c 1\ub144\uc804 \uc77c\ubcc4 \ub9e4\ucd9c\uc5d0\uc11c \uc788\ub294\uc9c0 \ucc3e\uac8c \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc5d0\ub294 \uc788\uae30 \ub54c\ubb38\uc5d0 \ud574\ub2f9 \ud589\uc5d0 1\uac1c\uc6d4 \uc804 \ub9e4\ucd9c\uc744 \ud45c\uc2dc\ud574\uc90d\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ucd1d 5\ubc88\uc758 \uc870\uc778\ub3c4 \ub3d9\uc77c\ud55c \ubc29\uc2dd\uc73c\ub85c \uc774\ub8e8\uc5b4\uc9c0\uba70, \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 \ub0a0\uc9dc\uac00 \ub204\ub77d\uc774 \uc5c6\uc73c\uba74\uc11c\ub3c4 \ud55c \uc5f4\ub85c \ud1b5\ud569\uc774 \ub418\uc5b4\uc11c \ud45c\uc2dc\ub418\uac8c \ub429\ub2c8\ub2e4.<br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br>\uc624\ub298\uc758 \ud3ec\uc2a4\ud2b8\uc5d0\uc11c\ub294 <code><code><code><code><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\"><strong>FULL OUTER JOIN<\/strong><\/mark><\/code><\/code><\/code><\/code><\/code> \uacfc <strong><code><mark style=\"background-color:var(--global-palette7);color:#e331ce\" class=\"has-inline-color\">COALESCE<\/mark><\/code> <\/strong>\ub97c \uac01\uac01 \uc18c\uac1c\ud558\uace0, \uc801\uc808\ud788 \uacb0\ud569\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc18c\uac1c\ud558\uc600\uc2b5\ub2c8\ub2e4. \ubcf5\uc7a1\ud55c \uc694\uad6c \uc0ac\ud56d\ub4e4\uc744 \uc218\ud589\ud558\ub2e4\ubcf4\uba74 \ucffc\ub9ac\uc758 \uae38\uc774\uac00 \ub108\ubb34 \uae38\uc5b4\uc9c8 \ub54c\uac00 \uc788\uc9c0\uc694. \uadf8\ub7f4 \ub54c\uc5d0 \uc774\ub7ec\ud55c \uad6c\ubb38\ub4e4\uc744 \uc801\uc808\ud788 \ud65c\uc6a9\ud558\uba74 \ubcf4\ub2e4 \uae54\ub054\ud55c \ucffc\ub9ac\ub85c \ubaa9\uc801\uc744 \ub2ec\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc624\ub298 \uc0b4\ud3b4\ubcf8 \uc720\uc6a9\ud55c \uad6c\ubb38\ub4e4\ub3c4 \uc2e4\ubb34\uc5d0 \ud65c\uc6a9\ud574\ubcf4\uc2dc\uae38 \ubc14\ub78d\ub2c8\ub2e4!<br><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"691\" height=\"512\" src=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-2.png\" alt=\"\" class=\"wp-image-17105\" srcset=\"https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-2.png 691w, https:\/\/www.autooffice.co.kr\/wp\/wp-content\/uploads\/2025\/04\/image-27-2-300x222.png 300w\" sizes=\"auto, (max-width: 691px) 100vw, 691px\" \/><\/figure>\n\n\n\n<p><br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aioseo-\uc5c5\ubb34-\ud6a8\uc728\uc131-200-\uc62c\ub9ac\uae30-with-autooffice-\ub8e8\ucee4-\uc2a4\ud29c\ub514\uc624-\uac1c\ubc1c-\ubb38\uc758\ub294-\uad6c\uae00\ud3fc\uc744-\uc774\uc6a9\ud574\uc8fc\uc138\uc694\"><strong>\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<br>\ub8e8\ucee4 \uc2a4\ud29c\ub514\uc624 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/strong><\/h2>\n\n\n\n<p><br><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSfh9CSxm4aKG4Rhh6Xdh7Y6p5e_8ZhwWS_ryvxGOeQVIpmaRw\/viewform\" target=\"_blank\" rel=\"noopener\" title=\"\">\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><br><br><br><\/p>\n\n\n\n<p><br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ub370\uc774\ud130 \ubd84\uc11d\uc744 \uc704\ud574\uc11c\ub294 SQL\ubb38\ubc95\uc758 JOIN\uc744 \uc774\ud574\ud558\ub294 \uac83\uc774 \ud544\uc218\uc801\uc785\ub2c8\ub2e4. INNER JOIN, LEFT JOIN, FULL OUTER JOIN \ub4f1 \ub2e4\uc591\ud55c JOIN \ubb38\ubc95\uc744 \ud65c\uc6a9\ud558\uba74 \uc5ec\ub7ec \uac1c\uc758 \ud14c\uc774\ube14\uc5d0 \ud769\uc5b4\uc838 \uc788\ub294 \ub370\uc774\ud130\ub97c \ud558\ub098\ub85c \uacb0\ud569\ud558\uc5ec \ub354 \ud3ed\ub113\uc740 \ubd84\uc11d\uc744 \uac00\ub2a5\ud558\uac8c \ud569\ub2c8\ub2e4. SQL\ubb38\ubc95\uc758 \uaf43\uc774\ub77c\uace0\ub3c4 \ud560 \uc218 \uc788\uc9c0\uc694. \ud83d\udca1\uc870\uc778\uc758 \uac1c\ub150\uc744 \uc54c\uace0\uc2f6\uc73c\uc2dc\ub2e4\uba74 \uc544\ub798\uc758 \ub9c1\ud06c\uc5d0 \ub4e4\uc5b4\uac00\ubcf4\uc138\uc694. [SQL] JOIN \ud55c \ubc29\uc5d0 \uc815\ub9ac &#8211; \uac1c\ub150\ubd80\ud130 \ucf54\ub4dc\uae4c\uc9c0 \uc774\uac83\ub9cc \ubcf4\uc790 \uc774\ubc88&#8230;<\/p>\n","protected":false},"author":6,"featured_media":16849,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[6,41],"tags":[551,567,100,546,559,54,12],"class_list":["post-16848","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-lookerstudio","category-bigquery","tag-autooffice","tag-looker-studio","tag-100","tag-546","tag-559","tag-54","tag-12"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16848","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=16848"}],"version-history":[{"count":6,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16848\/revisions"}],"predecessor-version":[{"id":17122,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/16848\/revisions\/17122"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/16849"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=16848"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=16848"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=16848"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}