{"id":4498,"date":"2018-02-12T10:00:54","date_gmt":"2018-02-12T18:00:54","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4498"},"modified":"2025-06-13T20:09:22","modified_gmt":"2025-06-14T03:09:22","slug":"join-queries-couchbase-mobile","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/join-queries-couchbase-mobile\/","title":{"rendered":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubaa8\ubc14\uc77c\uc758 \uc870\uc778 \ucffc\ub9ac \uc18c\uac1c"},"content":{"rendered":"<p>Couchbase Lite 2.0\uc740 JSON \ubb38\uc11c\uc5d0\uc11c JOIN\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\uac83\uc740 \ub2e4\uc74c\uc744 \uae30\ubc18\uc73c\ub85c \ud558\ub294 \uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uc778\ud130\ud398\uc774\uc2a4\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/n1ql\/\">N1QL<\/a>\ub294 JSON\uc6a9 SQL\uc744 \ud655\uc7a5\ud558\ub294 Couchbase\uc758 \uc120\uc5b8\uc801 \ucffc\ub9ac \uc5b8\uc5b4\uc785\ub2c8\ub2e4. SQL\uc5d0 \uc775\uc219\ud558\ub2e4\uba74 \uc0c8\ub85c\uc6b4 API\uc758 \uc758\ubbf8\ub97c \uc27d\uac8c \uc774\ud574\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/p>\n<p>JOIN\uc744 \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec \ubb38\uc11c\uc758 \ucf58\ud150\uce20\ub97c \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 Couchbase Lite\uc5d0\uc11c \uac00\ub2a5\ud55c JOIN\uc758 \uc720\ud615\uc744 \uc124\uba85\ud558\uae30 \uc704\ud574 \uc608\uc81c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uac01 \ucffc\ub9ac\uc5d0 \ub300\ud574 \ud574\ub2f9\ud558\ub294 SQL \ucffc\ub9ac\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4. \uc774 \ube14\ub85c\uadf8\ub294 \uc0c8\ub85c\uc6b4 \ucffc\ub9ac API\uc758 \uae30\ubcf8 \uc0ac\ud56d\uc5d0 \uc775\uc219\ud558\ub2e4\uace0 \uac00\uc815\ud558\ubbc0\ub85c, \uc544\uc9c1 \uc219\uc9c0\ud558\uc9c0 \uc54a\uc740 \uacbd\uc6b0 \ubc18\ub4dc\uc2dc <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/sql-for-json-query-interface-couchbase-mobile\/\">\uc774\uc804 \uac8c\uc2dc\ubb3c<\/a> \ub97c \uba3c\uc800 \uc77d\uc5b4 \ubcf4\uc138\uc694. \uad00\uc2ec\uc774 \uc788\uc73c\uc2dc\ub2e4\uba74 \uc774 \uae00\uc758 \ub05d\uc5d0 \ucffc\ub9ac \uc778\ud130\ud398\uc774\uc2a4\uc758 \ub2e4\ub978 \uae30\ub2a5\uc5d0 \ub300\ud574 \uc124\uba85\ud558\ub294 \ube14\ub85c\uadf8 \ub9c1\ud06c\uac00 \uc81c\uacf5\ub429\ub2c8\ub2e4.<\/p>\n<p>\ucd5c\uc2e0 Couchbase Mobile 2.0 \uc0ac\uc804 \ub9b4\ub9ac\uc2a4 \ube4c\ub4dc\ub294 \ub2e4\uc74c\uc5d0\uc11c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/mobile\/2.0\/whatsnew.html\">\ub2e4\uc6b4\ub85c\ub4dc<\/a> \ud398\uc774\uc9c0\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.<\/p>\n<p><!--more--><\/p>\n<h3 id=\"background\">\ubc30\uacbd<\/h3>\n<p>1.x \ubc84\uc804\uc758 Couchbase Mobile\uc744 \uc0ac\uc6a9 \uc911\uc774\ub77c\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \ub0b4\uc6a9\uc744 \uc798 \uc54c\uace0 \uacc4\uc2e4 \uac83\uc785\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/mobile\/1.4\/training\/develop\/using-the-database\/index.html#query-documents\">\ub9f5 \ubcf4\uae30<\/a> \ub97c \uc0ac\uc6a9\ud558\uc5ec \uc778\ub371\uc2a4\uc640 \ucffc\ub9ac\ub97c \ub9cc\ub4e4 \uc218 \uc788\uc2b5\ub2c8\ub2e4. 2.0\uc5d0\uc11c\ub294 \ub354 \uc774\uc0c1 \ubdf0\uc640 \ub9f5 \ud568\uc218\ub97c \ub9cc\ub4e4 \ud544\uc694\uac00 \uc5c6\uc2b5\ub2c8\ub2e4! \ub300\uc2e0, \uac04\ub2e8\ud55c \uc778\ud130\ud398\uc774\uc2a4\ub97c \ud1b5\ud574 \uc778\ub371\uc2a4\ub97c \uc0dd\uc131\ud558\uace0 \ucffc\ub9ac \ube4c\ub354 \uc778\ud130\ud398\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud574 \ucffc\ub9ac\ub97c \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uc778\ud130\ud398\uc774\uc2a4\ub294 \uc0ac\uc6a9\ud558\uae30 \ub354 \uac04\ub2e8\ud558\uace0 \ud6e8\uc52c \ub354 \uac15\ub825\ud569\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c \uba87 \uac00\uc9c0 \uae30\ub2a5\uc744 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<h3 id=\"sampleproject\">\uc0d8\ud50c \ud504\ub85c\uc81d\ud2b8<\/h3>\n<p>\uc5ec\uae30\uc11c \uc124\uba85\ud558\ub294 \uc608\uc81c\uc5d0\uc11c\ub294 iOS\uc6a9 Swift\ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc, \ub3d9\uc77c\ud55c \ucffc\ub9ac \uc778\ud130\ud398\uc774\uc2a4\ub294 Android \ubc0f Windows \ud50c\ub7ab\ud3fc\uc5d0\uc11c\ub3c4 \uc9c0\uc6d0\ub429\ub2c8\ub2e4.<\/p>\n<p><strong>\ub530\ub77c\uc11c \uc57d\uac04\uc758 \uc218\uc815\ub9cc \ud558\uba74 \ub2e4\ub978 \ud50c\ub7ab\ud3fc\uc5d0\uc11c \uc791\uc5c5\ud560 \ub54c \uc774 \uae00\uc758 \ucffc\ub9ac \uc608\uc81c\ub97c \uc7ac\uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/strong><\/p>\n<p>\uc0d8\ud50c Swift \ud504\ub85c\uc81d\ud2b8\uc5d0 \uad00\uc2ec\uc774 \uc788\ub2e4\uba74 \uc544\ub798 \uc9c0\uce68\uc744 \ub530\ub974\uc138\uc694.<\/p>\n<ul>\n<li>GitHub\uc5d0\uc11c iOS Swift \ud50c\ub808\uc774\uadf8\ub77c\uc6b4\ub4dc \ubcf5\uc81c\ud558\uae30<\/li>\n<\/ul>\n<pre><code>$ git clone https:\/\/github.com\/couchbaselabs\/couchbase-lite-ios-api-playground<\/code><\/pre>\n<ul>\n<li>\ud574\ub2f9 \ud56d\ubaa9\uc758 \uc124\uce58 \uc9c0\uce68\uc744 \ub530\ub974\uc138\uc694. <a href=\"https:\/\/github.com\/couchbaselabs\/couchbase-lite-ios-api-playground\/blob\/master\/README.md\">README<\/a> \ud30c\uc77c\uc744 \uc0ac\uc6a9\ud558\uc5ec \ud50c\ub808\uc774\uadf8\ub77c\uc6b4\ub4dc\ub97c \ube4c\ub4dc\ud558\uace0 \uc2e4\ud589\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<h3 id=\"sampledatamodel\">\uc0d8\ud50c \ub370\uc774\ud130 \ubaa8\ub378<\/h3>\n<p>\ub2e4\uc74c \uc704\uce58\uc5d0 \uc788\ub294 \uc0d8\ud50c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. <a href=\"https:\/\/github.com\/couchbaselabs\/couchbase-lite-ios-api-playground\/tree\/master\/joindb.cblite2\">\uc5ec\uae30<\/a>. \uc774 \uc0ac\uc804 \uad6c\ucd95\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ubaa8\ubc14\uc77c \uc560\ud50c\ub9ac\ucf00\uc774\uc158\uc5d0 \uc784\ubca0\ub4dc\ud558\uc5ec \ucffc\ub9ac\uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc0d8\ud50c \ub370\uc774\ud130 \uc138\ud2b8\ub294 \uc57d\uac04 \uc778\uc704\uc801\uc774\uc9c0\ub9cc \uc5ec\uae30\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uba87 \uac00\uc9c0 \uc77c\ubc18\uc801\uc778 \uc0ac\uc6a9 \uc0ac\ub840\ub97c \ubcf4\uc5ec\uc8fc\uae30 \uc704\ud55c \uac83\uc785\ub2c8\ub2e4. <code>join<\/code> \ucffc\ub9ac.<\/p>\n<ul>\n<li>\"\uc9c1\uc6d0\" \uc720\ud615 \ubb38\uc11c<\/li>\n<\/ul>\n<pre class=\"lang:js decode:true\">{\r\n \"type\": \"\uc9c1\uc6d0\",\r\n \"\uc774\ub984\": \"John\",\r\n \"\uc131\": \"Smith\",\r\n \"\ubd80\uc11c\": \"1000\",\r\n \"\uc704\uce58\": \"101\"\r\n}<\/pre>\n<ul>\n<li>\"\ubd80\uc11c\" \uc720\ud615 \ubb38\uc11c<\/li>\n<\/ul>\n<pre class=\"lang:js decode:true\">{\r\n \"type\": \"\ubd80\uc11c\",\r\n \"name\": \"\uc81c\ud488 \uad00\ub9ac\",\r\n \"\ucf54\ub4dc\": \"2000\",\r\n \"head\": {\r\n \"\uc774\ub984\": \"Patricia\",\r\n \"\uc131\": \"Shoji\"\r\n },\r\n \"location\":[\"101\",\"102\"]\r\n}\r\n<code><\/code><\/pre>\n<ul>\n<li>\"\uc704\uce58\" \uc720\ud615 \ubb38\uc11c<\/li>\n<\/ul>\n<pre class=\"lang:js decode:true\">{\r\n \"type\": \"\uc704\uce58\",\r\n \"name\": \"HQ\",\r\n \"\uc8fc\uc18c\": \"1123 6th St. \uba5c\ubc84\ub978, FL 32904\",\r\n \"\ucf54\ub4dc\": \"101\"\r\n}<\/pre>\n<p>** \uc544\ub798\uc758 \uac01 \ucffc\ub9ac \uc608\uc81c\ub294 \uc704\uc758 \ubaa8\ub378\uc744 \ucc38\uc870\ud558\uc138\uc694. **<\/p>\n<h3 id=\"thedatabasehandle\">\ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud578\ub4e4<\/h3>\n<p>\uc544\ub798 \ucffc\ub9ac\uc5d0\uc11c\ub294 \ub2e4\uc74c\uacfc \uac19\uc774 <a href=\"https:\/\/developer.couchbase.com\/documentation\/mobile\/2.0\/guides\/couchbase-lite\/native-api\/database\/index.html\"><code>\ub370\uc774\ud130\ubca0\uc774\uc2a4<\/code><\/a> API\ub97c \uc0ac\uc6a9\ud558\uc5ec CouchbaseLite \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f4\uac70\ub098 \uc0dd\uc131\ud569\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:swift decode:true\"> let options = DatabaseConfiguration()\r\n let db = try \ub370\uc774\ud130\ubca0\uc774\uc2a4(\uc774\ub984: kDBName, \uad6c\uc131: \uc635\uc158)<\/pre>\n<h3 id=\"indexes\">\uc0c9\uc778<\/h3>\n<p>\uc77d\uae30 \ucffc\ub9ac \uc18d\ub3c4\ub97c \ub192\uc774\ub824\uba74 \ucffc\ub9ac\ud560 \uc18d\uc131\uc5d0 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uba74 \ub429\ub2c8\ub2e4. \ub300\uaddc\ubaa8 \ub370\uc774\ud130 \uc138\ud2b8\uc5d0\uc11c \uc131\ub2a5 \ud5a5\uc0c1\uc740 \uc0c1\ub2f9\ud560 \uac83\uc785\ub2c8\ub2e4. \ubb3c\ub860 \uc778\ub371\uc2a4\ub97c \uc800\uc7a5\ud558\uae30 \uc704\ud574 \ud544\uc694\ud55c \uc2a4\ud1a0\ub9ac\uc9c0\uac00 \uc99d\uac00\ud558\uace0 \uc4f0\uae30 \uc131\ub2a5\uc5d0\ub3c4 \uc601\ud5a5\uc744 \ubbf8\uce60 \uc218 \uc788\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud558\uc138\uc694. \ub530\ub77c\uc11c \ub108\ubb34 \ub9ce\uc740 \uc778\ub371\uc2a4\ub97c \ub9cc\ub4e4\uc9c0 \uc54a\ub3c4\ub85d \uc8fc\uc758\ud558\uc138\uc694.<\/p>\n<p>\ub2e4\uc74c \uc608\uc81c\uc5d0\uc11c\ub294 <code>ValueIndex<\/code> \uc5d0\uc11c <code>\uc720\ud615<\/code> \ubb38\uc11c\uc758 \uc18d\uc131<\/p>\n<pre class=\"wrap:true lang:swift decode:true\"> db.createIndex(IndexBuilder.valueIndex(items: ValueIndexItem.property(\"type\")),withName: \"typeIndex\")<\/pre>\n<h3 id=\"joinorinnerjoin\">\uc870\uc778 \ub610\ub294 \ub0b4\ubd80 \uc870\uc778<\/h3>\n<p>\ub450 \ubb38\uc11c \ubaa8\ub450\uc5d0 \uc9c0\uc815\ub41c \uc870\uac74\uc744 \ucda9\uc871\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc \uac04\ub2e8\ud55c \uc870\uc778 \ub610\ub294 \ub0b4\ubd80 \uc870\uc778 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc38\uc5ec \ubb38\uc11c\uc5d0\uc11c \uc18d\uc131\uc744 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\ucf1c\uae30<\/code> \uc808\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc55e\uc11c \uc81c\uc2dc\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uace0\ub824\ud560 \ub54c, \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <code>\uc774\ub984<\/code>, <code>\uc131<\/code> \"\uc9c1\uc6d0\"\uacfc \ud574\ub2f9 <code>\uc774\ub984<\/code> \uc9c1\uc6d0\uc774 \uc18c\uc18d\ub41c '\ubd80\uc11c'\uc758 \uc774\ub984\uc785\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 <code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \ud504\ub85c\ud37c\ud2f0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\" \ubc0f \ubd80\uc11c <code>\uc774\ub984<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\ubd80\uc11c\"\uc5d0 \ud574\ub2f9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc <code>\ubd80\uc11c<\/code> \uc18d\uc131\uc740 \"\uc9c1\uc6d0\"\uc758 \ud574\ub2f9 \uc18d\uc131\uacfc \uc77c\uce58\ud558\ub294 <code>\ucf54\ub4dc<\/code> \uc18d\uc131\uc744 \"\ubd80\uc11c\"<\/p>\n<p>\uc989, '\ubd80\uc11c'\uc640 \uc77c\uce58\ud558\ub294 \ubb38\uc11c\uac00 \uc5c6\ub294 \uacbd\uc6b0 <code>\ucf54\ub4dc<\/code> \ub97c '\uc9c1\uc6d0' \ubb38\uc11c\uc5d0 \uc785\ub825\ud558\uba74 \ud574\ub2f9 \uc9c1\uc6d0\uc758 \uc138\ubd80 \uc815\ubcf4\uac00 \ucd9c\ub825 \uacb0\uacfc\uc5d0 \ud3ec\ud568\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/inner_join_explain.png\" alt=\"\" \/><\/figure>\n<h4 id=\"request\">\uc694\uccad<\/h4>\n<pre class=\"wrap:true lang:swift decode:true\"> db.createIndex(IndexBuilder.valueIndex(items: ValueIndexItem.property(\"type\")),withName: \"typeIndex\")\r\n\/\/ \"department\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\nlet departmentDS = DataSource.database(db).as(\"departmentDS\")\r\n\r\n\/\/ \"department\"(\uc9c1\uc6d0 \ubb38\uc11c\uc5d0\uc11c)\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd \uc124\uc815\r\nlet employeeDeptExpr = Expression.property(\"department\").from(\"employeeDS\")\r\n\r\n\/\/ (\ubd80\uc11c \ubb38\uc11c\uc5d0\uc11c) \"code\"\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd\r\nlet departmentCodeExpr = Expression.property(\"code\").from(\"departmentDS\")\r\n\r\n\/\/ \uc870\uc778 \uc808\uc785\ub2c8\ub2e4: \uc9c1\uc6d0 \uc720\ud615\uacfc \ubd80\uc11c \uc720\ud615 \ubb38\uc11c\ub97c \uc870\uc778\ud569\ub2c8\ub2e4.\r\n\/\/ \uc9c1\uc6d0 \ubb38\uc11c\uc758 \"\ubd80\uc11c\" \ud544\ub4dc\uac00 \ubd80\uc11c \"\ucf54\ub4dc\"\uc640 \ub3d9\uc77c\ud55c \uacbd\uc6b0;\r\n\/\/ \"\ubd80\uc11c\" \ubb38\uc11c\uc758\r\nlet joinExpr = employeeDeptExpr.equalTo(departmentCodeExpr)\r\n    .and(Expression.property(\"type\").from(\"employeeDS\").equalTo(Expression.string(\"employee\")))\r\n    .and(Expression.property(\"type\").from(\"departmentDS\").equalTo(Expression.string(\"department\")))\r\n\r\n\r\n\/\/ ON \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0b4\ubd80 \uc870\uc778 \uc2dd\uc744 \uc791\uc131\ud569\ub2c8\ub2e4.\r\nlet join = Join.join(departmentDS).on(joinExpr)\r\n\r\n\/\/ \uc870\uc778\ub41c \ubb38\uc11c\uc5d0\uc11c \"firstname\", \"lastname\"; \ubc0f \"department\"; \uc774\ub984\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.\r\n\/\/ JOIN \ud45c\ud604\uc2dd\uc5d0 \ub530\ub77c\r\nlet searchQuery = Query.select(\r\n    SelectResult.expression(Expression.property(\"firstname\").from(\"employeeDS\")),\r\n    SelectResult.expression(Expression.property(\"lastname\").from(\"employeeDS\")),\r\n    SelectResult.expression(Expression.property(\"name\").from(\"departmentDS\")))\r\n    .from(employeeDS)\r\n    .join(join)<\/pre>\n<p>&nbsp;<\/p>\n<h4>ANSI SQL<\/h4>\n<p>\uc704 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:mysql decode:true\">SELECT\r\n  employeeDS.name,\r\n  employeeDS.\uc131\r\n  departmentDS.name\r\nFROM\r\n  travel-sample` employeeDS\r\n  INNER JOIN `travel-sample` departmentDS ON employeeDS.department = departmentDS.code\r\nWHERE\r\n  employeeDS.type = \"employee\"\r\n  AND departmentDS.type = \"department\"<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"leftjoinorleftouterjoin\">\uc67c\ucabd \uc870\uc778 \ub610\ub294 \uc67c\ucabd \uc678\ubd80 \uc870\uc778<\/h3>\n<p>\ub450 \ubb38\uc11c\uac00 \ubaa8\ub450 \uc9c0\uc815\ub41c \uc870\uac74\uc744 \ucda9\uc871\ud558\ub294 \uacbd\uc6b0 \uc67c\ucabd \uc870\uc778 \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc38\uc5ec \ubb38\uc11c\uc5d0\uc11c \uc18d\uc131\uc744 \uac00\uc838\uc62c \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\ucf1c\uae30<\/code> \uc808\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc77c\ubc18 \uc870\uc778\uacfc \ub2ec\ub9ac \uacb0\uacfc\uc5d0\ub294 \uc77c\uce58\ud558\uc9c0 \uc54a\ub294 \ubb38\uc11c\uac00 \uc67c\ucabd\uc5d0 \uc788\ub294 <code>\ucf1c\uae30<\/code> \uc808\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc55e\uc11c \uc81c\uc2dc\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uace0\ub824\ud560 \ub54c, \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <code>\uc774\ub984<\/code>, <code>\uc131<\/code> \"\uc9c1\uc6d0\"\uacfc \ud574\ub2f9 <code>\uc774\ub984<\/code> \uc9c1\uc6d0\uc774 \uc18c\uc18d\ub41c '\ubd80\uc11c'\uc758 \uc774\ub984\uc785\ub2c8\ub2e4.<br \/>\n\ub610\ud55c \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0\ub3c4 \uad00\uc2ec\uc774 \uc788\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \"\uc9c1\uc6d0\"\uc758 <code>\ubd80\uc11c<\/code> \ucf54\ub4dc\uac00 \uc218\ud589\ud558\ub294 \uc791\uc5c5 <em>not<\/em> \ub294 \uc720\ud6a8\ud55c \ubd80\uc11c\uc5d0 \ud574\ub2f9\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 \ub2e4\uc74c\uacfc \uac19\uc740 \uacbd\uc6b0\uc5d0 \ud574\ub2f9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\ubd80\uc11c<\/code> \uc9c1\uc6d0\uc758 \ucf54\ub4dc\uac00 \uc798\ubabb \uc785\ub825\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uacbd\uc6b0 <code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \ud504\ub85c\ud37c\ud2f0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\" \ubc0f \ubd80\uc11c <code>\uc774\ub984<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\ubd80\uc11c\"\uc778 \uacbd\uc6b0 <code>\ubd80\uc11c<\/code> \uc18d\uc131\uc740 \"\uc9c1\uc6d0\"\uc758 \ud574\ub2f9 \uc18d\uc131\uacfc \uc77c\uce58\ud558\ub294 <code>\ucf54\ub4dc<\/code> \uc18d\uc131\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc77c\uce58\ud558\ub294 \ubd80\uc11c\uac00 \uc5c6\ub294 \uacbd\uc6b0\uc5d0\ub294 <code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \uc18d\uc131\uc774 \ubc18\ud658\ub429\ub2c8\ub2e4.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/outer_join_explain.png\" alt=\"\" \/><\/figure>\n<h4 id=\"request\">\uc694\uccad<\/h4>\n<pre class=\"wrap:true lang:swift decode:true\"> \/\/ \"employee\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let employeeDS = DataSource.database(db).as(\"employeeDS\")\r\n\/\/ \"department\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\nlet departmentDS = DataSource.database(db).as(\"departmentDS\")\r\n\r\n\/\/ (\uc9c1\uc6d0 \ubb38\uc11c\uc5d0\uc11c) \"department\"\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd \uc124\uc815\r\nlet employeeDeptExpr = Expression.property(\"department\").from(\"employeeDS\")\r\n\r\n\/\/ (\ubd80\uc11c \ubb38\uc11c\uc5d0\uc11c) \"code\"\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd\r\nlet departmentCodeExpr = Expression.property(\"code\").from(\"departmentDS\")\r\n\r\n\/\/ \uc870\uc778 \uc808\uc785\ub2c8\ub2e4: \ubd80\uc11c \uc720\ud615\uacfc \uc9c1\uc6d0 \uc720\ud615 \ubb38\uc11c\ub97c \uc870\uc778\ud569\ub2c8\ub2e4.\r\n\/\/ \uc9c1\uc6d0 \ubb38\uc11c\uc758 \"\ubd80\uc11c\" \ud544\ub4dc\uac00 \ubd80\uc11c \"\ucf54\ub4dc\"\uc640 \ub3d9\uc77c\ud55c\r\n\/\/ \"\ubd80\uc11c\" \ubb38\uc11c\r\nlet joinExpr = employeeDeptExpr.equalTo(departmentCodeExpr)\r\n    .and(Expression.property(\"type\").from(\"employeeDS\").equalTo(Expression.string(\"employee\")))\r\n    .and(Expression.property(\"type\").from(\"departmentDS\").equalTo(Expression.string(\"department\")))\r\n\r\n\r\n\/\/ ON \ucffc\ub9ac\ub85c \ud45c\ud604\uc2dd \uc870\uc778\r\nlet join = Join.leftJoin(departmentDS).on(joinExpr)\r\n\r\n\/\/ JOIN \ud45c\ud604\uc2dd\uc744 \uae30\ubc18\uc73c\ub85c \uc870\uc778\ub41c \ubb38\uc11c\uc5d0\uc11c \"\uc774\ub984\", \"\uc131\" \ubc0f \"\ubd80\uc11c\" \uc774\ub984\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.\r\n let searchQuery = Query.select(\r\n     SelectResult.expression(Expression.property(\"firstname\").from(\"employeeDS\")),\r\n     SelectResult.expression(Expression.property(\"lastname\").from(\"employeeDS\")),\r\n     SelectResult.expression(Expression.property(\"name\").from(\"departmentDS\")))\r\n    .from(employeeDS)\r\n    .join(join)<\/pre>\n<h4>ANSI SQL<\/h4>\n<p>\uc704 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:mysql decode:true\"> SELECT\r\n  employeeDS.name,\r\n  employeeDS.\uc131\r\n  departmentDS.name\r\nFROM\r\n  travel-sample` employeeDS\r\n  LEFT JOIN `travel-sample` departmentDS ON employeeDS.department = departmentDS.code\r\nWHERE\r\n  employeeDS.type = \"employee\"\r\n  AND departmentDS.type = \"department\"<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"crossjoin\">\uad50\ucc28 \uac00\uc785<\/h3>\n<p>\uad50\ucc28 JOIN \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ucc38\uc5ec \ubb38\uc11c\uc5d0\uc11c \uc18d\uc131\uc758 \uc9c1\uad50\uacf1\uc744 \uac00\uc838\uc62c \uc218 \uc788\uc73c\uba70, \uc77c\ubc18\uc801\uc73c\ub85c \ubb38\uc11c\ub294 \uc11c\ub85c \uad00\ub828\uc774 \uc5c6\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \ub0b4\ubd80 JOIN\uacfc \ub3d9\uc77c\ud569\ub2c8\ub2e4. <em>\uc5c6\uc774<\/em> \uc758 <code>\ucf1c\uae30<\/code> \uc808\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc55e\uc11c \uc81c\uc2dc\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uace0\ub824\ud558\uc5ec \ub2e4\uc74c\uacfc \uac19\uc740 \ubaa8\ub4e0 \ubb38\uc11c\uc758 \uc9c1\uad50\uacf1\uc744 \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc704\uce58\" \ubc0f <code>\uc720\ud615<\/code> \"\ubd80\uc11c\". \uc989, \ubaa8\ub4e0 \"\uc704\uce58\" <code>\uc720\ud615<\/code> \ubb38\uc11c\uac00 \uac01 \"\ubd80\uc11c\"\uc640 \uacb0\ud569\ub429\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \ubb38\uc11c.<\/p>\n<p>\ub530\ub77c\uc11c <code>on<\/code> \uc808\uc744 \ud3ec\ud568\ud558\ub294 \uacbd\uc6b0, \uad50\ucc28 \uc870\uc778 \ud45c\ud604\uc2dd\uc5d0 \uc9c0\uc815\ub41c <code>\uc5b4\ub514<\/code> \uc808\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubb38\uc11c\uc5d0 \ub530\ub77c \uace0\ub824\ud560 \ubb38\uc11c\uc758 \ud558\uc704 \uc9d1\ud569\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4. <code>\uc720\ud615<\/code>.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/cross_join_explain.png\" alt=\"\" \/><\/figure>\n<h4 id=\"request\">\uc694\uccad<\/h4>\n<pre class=\"wrap:true lang:swift decode:true\">\/\/ \"department\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let departmentDS = DataSource.database(db).as(\"departmentDS\")\r\n\/\/ \"location\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\nlet locationDS = DataSource.database(db).as(\"locationDS\")\r\n\r\n\/\/ (\uc9c1\uc6d0 \ubb38\uc11c\uc5d0\uc11c) \"\ubd80\uc11c\"\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd \uc124\uc815\r\nlet employeeDeptExpr = Expression.property(\"code\").from(\"departmentDS\")\r\n\r\n\/\/ (\uc704\uce58 \ubb38\uc11c\uc5d0\uc11c) \"department\"\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd\r\nlet departmentCodeExpr = Expression.property(\"code\").from(\"locationDS\")\r\n\r\n\/\/ \uad50\ucc28 \uc870\uc778 \ud45c\ud604\uc2dd\r\nlet join = Join.crossJoin(locationDS)\r\n\r\n\/\/ \uc720\ud615 \uc18d\uc131 \ud45c\ud604\uc2dd\r\nlet deptTypeExpr = Expression.property(\"type\").from(\"departmentDS\")\r\nlet locationTypeExpr = Expression.property(\"type\").from(\"locationDS\")\r\n\r\n\/\/ where \uc808\uc740 \uad50\ucc28 \uc870\uc778\ud560 \ubb38\uc11c \uc9d1\ud569\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.\r\n\/\/ \"code\" \uc18d\uc131\uc740 \ubd80\uc11c \ubb38\uc11c\uc640 \uc704\uce58 \ubb38\uc11c \ubaa8\ub450\uc5d0 \uc874\uc7ac\ud558\ubbc0\ub85c \ubcc4\uce6d\uc744 \ubd99\uc785\ub2c8\ub2e4.\r\n\r\n\/\/ \ucc38\uace0: where \uc808\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uace0\ub824\ud560 \ubb38\uc11c\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.\r\n\/\/ \uce74\ub974\ud14c\uc2dc\uc548 \uc870\uc778\uc758 \uc77c\ubd80\ub85c \uac04\uc8fc\ub418\ub294 \ubb38\uc11c\ub97c \ud544\ud130\ub9c1\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4.\r\nlet searchQuery = Query.select(\r\n    SelectResult.expression(Expression.property(\"name\").from(\"departmentDS\")).as(\"DeptName\"),\r\n     SelectResult.expression(Expression.property(\"name\").from(\"locationDS\")).as(\"LocationName\"),\r\n    SelectResult.expression(Expression.property(\"address\").from(\"locationDS\")))\r\n    .from(departmentDS)\r\n    .join(join)\r\n    .where(deptTypeExpr.equalTo(Expression.string(\"department\"))\r\n                .and(locationTypeExpr.equalTo(Expression.string(\"location\"))))<\/pre>\n<h4>ANSI SQL<\/h4>\n<p>\uc704 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:mysql decode:true\">SELECT\r\n  departmentDS.name AS DeptName,\r\n  locationDS.name AS LocationName,\r\n  locationDS.address\r\nFROM\r\n  `travel-sample` departmentDS\r\n  CROSS JOIN `travel-sample` locationDS\r\nWHERE\r\n  departmentDS.type = \"department\"<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"chainingofjoins\">\uc870\uc778 \uc5f0\uacb0<\/h3>\n<p>\uc5ec\ub7ec JOIN \ud45c\ud604\uc2dd\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <code>\uc120\ud0dd<\/code> \uc808\uc744 \ucd94\uac00\ud558\uc5ec \ub2e4\uc591\ud55c \uae30\uc900\uc5d0 \ub530\ub77c \ubb38\uc11c \uac04\uc5d0 \uc870\uc778\ud560 \uc218 \uc788\ub3c4\ub85d \ud569\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4 \uc55e\uc11c \uc81c\uc2dc\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uace0\ub824\ud560 \ub54c, \ub2e4\uc74c\uacfc \uac19\uc740 \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uac00\uc838\uc624\uace0 \uc2f6\ub2e4\uace0 \uac00\uc815\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <code>\uc774\ub984<\/code>, <code>\uc131<\/code> \"\uc9c1\uc6d0\"\uacfc \ud574\ub2f9 <code>\uc774\ub984<\/code> \uc744 \uc0ac\uc6a9\ud558\uc5ec \uc9c1\uc6d0\uc774 \uc18c\uc18d\ub41c '\ubd80\uc11c'\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc9c1\uc6d0\uc774 \uc18d\ud55c <code>\uc774\ub984<\/code> \uc9c1\uc6d0\uc774 \uadfc\ubb34\ud588\ub358 '\uc704\uce58'\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uacbd\uc6b0 \ub450 \uac1c\uc758 JOIN \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<br \/>\n\uccab \ubc88\uc9f8 JOIN \ud45c\ud604\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc11c\ub97c \uc870\uc778\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\"\uc740 \ub2e4\uc74c \ubb38\uc11c\uc640 \ud568\uaed8 <code>\uc720\ud615<\/code> \"\ubd80\uc11c \ucf54\ub4dc\" \uc18d\uc131\uc744 \uae30\ubc18\uc73c\ub85c \"\ubd80\uc11c\"\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 <code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \ud504\ub85c\ud37c\ud2f0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\" \ubc0f \ubd80\uc11c <code>\uc774\ub984<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\ubd80\uc11c\"\uc5d0 \ud574\ub2f9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc <code>\ubd80\uc11c<\/code> \uc18d\uc131\uc740 \"\uc9c1\uc6d0\"\uc758 \ud574\ub2f9 \uc18d\uc131\uacfc \uc77c\uce58\ud558\ub294 <code>\ucf54\ub4dc<\/code> \uc18d\uc131\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n<p>\ub450 \ubc88\uc9f8 JOIN \ud45c\ud604\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc740 \ubb38\uc11c\ub97c \uc870\uc778\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\"\uc740 \ub2e4\uc74c \ubb38\uc11c\uc640 \ud568\uaed8 <code>\uc720\ud615<\/code> \"\uc704\uce58 \ucf54\ub4dc\" \uc18d\uc131\uc744 \uae30\ubc18\uc73c\ub85c \"\uc704\uce58\"\ub97c \uc124\uc815\ud569\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 <code>\uc774\ub984<\/code> \uadf8\ub9ac\uace0 <code>\uc131<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \ud504\ub85c\ud37c\ud2f0\ub97c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc9c1\uc6d0\" \ubc0f \uc704\uce58 <code>\uc774\ub984<\/code> \uc758 \ubb38\uc11c\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <code>\uc720\ud615<\/code> \"\uc704\uce58\"\uc5d0 \ud574\ub2f9\ud558\ub294 \uacbd\uc6b0\uc5d0\ub9cc <code>\uc704\uce58<\/code> \uc18d\uc131\uc740 \"\uc9c1\uc6d0\"\uc758 \ud574\ub2f9 \uc18d\uc131\uacfc \uc77c\uce58\ud558\ub294 <code>\ucf54\ub4dc<\/code> \uc18d\uc131\uc744 \ucd94\uac00\ud569\ub2c8\ub2e4.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/01\/multi-join.png\" alt=\"\" \/><\/figure>\n<h4 id=\"request\">\uc694\uccad<\/h4>\n<pre class=\"wrap:true lang:swift decode:true\"> \/\/ \"employee\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let employeeDS = DataSource.database(db).as(\"employeeDS\")\r\n \/\/ \"department\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let departmentDS = DataSource.database(db).as(\"departmentDS\")\r\n \/\/ \"location\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let locationDS = DataSource.database(db).as(\"locationDS\")\r\n \/\/ \"\ubd80\uc11c\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd(\uc9c1\uc6d0 \ubb38\uc11c\uc5d0\uc11c)\r\n let employeeDeptExpr = Expression.property(\"department\").from(\"employeeDS\")\r\n\r\n \/\/ \"\uc704\uce58\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd(\uc9c1\uc6d0 \ubb38\uc11c\uc5d0\uc11c)\r\n let employeeLocationExpr = Expression.property(\"location\").from(\"employeeDS\")\r\n\r\n \/\/ \"code\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd(\ubd80\uc11c \ubb38\uc11c\uc5d0\uc11c)\r\n let departmentCodeExpr = Expression.property(\"code\").from(\"departmentDS\")\r\n\r\n \/\/ \"\ucf54\ub4dc\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd (\uc704\uce58 \ubb38\uc11c\uc5d0\uc11c)\r\n let locationCodeExpr = Expression.property(\"code\").from(\"locationDS\")\r\n    \r\n \/\/ \uc870\uc778 \uae30\uc900 1\r\n \/\/ \uc9c1\uc6d0 \ubb38\uc11c\uc758 \"\ubd80\uc11c\" \ud544\ub4dc\uac00 \"\ubd80\uc11c\" \ubb38\uc11c\uc758 \ubd80\uc11c \"\ucf54\ub4dc\"\uc640 \ub3d9\uc77c\ud55c \uacbd\uc6b0 \uc870\uc778\ud569\ub2c8\ub2e4.\r\n let joinDeptCodeExpr = employeeDeptExpr.equalTo(departmentCodeExpr)\r\n        .and(Expression.property(\"type\").from(\"employeeDS\").equalTo(Expression.string(\"employee\")))\r\n        .and(Expression.property(\"type\").from(\"departmentDS\").equalTo(Expression.string(\"department\")))\r\n    \r\n\r\n \/\/ \uc870\uc778 \uc870\uac74 2\r\n \/\/ \uc9c1\uc6d0 \ubb38\uc11c\uc758 \"\ubd80\uc11c\" \ud544\ub4dc\uac00 \"\ubd80\uc11c\" \ubb38\uc11c\uc758 \ubd80\uc11c \"\ucf54\ub4dc\"\uc640 \ub3d9\uc77c\ud55c \uacbd\uc6b0 \uc870\uc778\ud569\ub2c8\ub2e4.\r\n let joinLocationCodeExpr = employeeLocationExpr.equalTo(locationCodeExpr)\r\n        .and(Expression.property(\"type\").from(\"employeeDS\").equalTo(Expression.string(\"employee\")))\r\n        .and(Expression.property(\"type\").from(\"locationDS\").equalTo(Expression.string(\"location\")))\r\n    \r\n \/\/ \ubd80\uc11c \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc870\uc778 \ud45c\ud604\uc2dd\r\n let joinDeptCode = Join.join(departmentDS).on(joinDeptCodeExpr)\r\n    \r\n \/\/ \uc704\uce58 \ucf54\ub4dc\uc5d0 \ub300\ud55c \uc870\uc778 \ud45c\ud604\uc2dd\r\n let joinLocationCode = Join.join(locationDS).on(joinLocationCodeExpr)\r\n    \r\n \/\/ \uc870\uc778 \uc808\uc758 \ub2e4\uc911 \uc870\uc778 \ud45c\ud604\uc2dd\r\n let searchQuery = QueryBuilder.select(SelectResult.expression(Expression.property(\"firstname\").from(\"employeeDS\")),\r\n       SelectResult.expression(Expression.property(\"lastname\").from(\"employeeDS\")),\r\n       SelectResult.expression(Expression.property(\"name\").from(\"departmentDS\")).as(\"deptName\"),\r\n       SelectResult.expression(Expression.property(\"name\").from(\"locationDS\")).as(\"locationName\"))\r\n        .from(employeeDS)\r\n        .join(joinDeptCode,joinLocationCode)<\/pre>\n<h3><\/h3>\n<h4>ANSI SQL<\/h4>\n<p>\uc704 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 SQL \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:mysql decode:true\">SELECT\r\n  employeeDS.name,\r\n  employeeDS.lastname,\r\n  departmentDS.name AS deptName,\r\n  locationDS.name AS locationName\r\nFROM\r\n  travel-sample` employeeDS\r\n  JOIN `travel-sample` departmentDS ON employeeDS.department = departmentDS.code\r\n  JOIN `travel-sample` locationDS ON employeeDS.location = locationDS.code\r\nWHERE\r\n  departmentDS.type = \"\ubd80\uc11c\"\r\n  AND locationDS.type = \"location\"\r\n  AND employeeDS.type = \"\uc9c1\uc6d0\"<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"joinexpressionswithfunctions\">\ud568\uc218\ub97c \uc0ac\uc6a9\ud55c \uc870\uc778 \ud45c\ud604\uc2dd<\/h3>\n<p>\ubaa8\ub4e0 \uc608\uc81c\uc5d0\uc11c <code>equalTo<\/code> \ube44\uad50\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0, \ub2e4\uc74c\uacfc \uac19\uc740 \ube44\uad50 \uc5f0\uc0b0\uc790\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc5d0 \uc720\uc758\ud574\uc57c \ud569\ub2c8\ub2e4. <code>\uc0ac\uc774<\/code>, <code>\ubcf4\ub2e4 \ud06c\uac70\ub098 \uac19\uc74c<\/code> \ub4f1\uc744 JOIN \ud45c\ud604\uc2dd\uc5d0 \ud3ec\ud568\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c \uc720\ud6a8\ud55c <code>\uae30\ub2a5<\/code> \ud45c\ud604\uc2dd\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \uac15\ub825\ud55c \uae30\ub2a5\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uc5b4, \uc55e\uc11c \uc81c\uc2dc\ud55c \ub370\uc774\ud130 \ubaa8\ub378\uc744 \uace0\ub824\ud558\uc5ec \ubd80\uc11c\uc5d0\uc11c <code>\uc774\ub984<\/code> \ubc0f \ud574\ub2f9 <code>\uc704\uce58<\/code> \ubd80\uc11c\uac00 \uc704\uce58\ud55c '\uc704\uce58'\uc758 \uc774\ub984\uc785\ub2c8\ub2e4. \ubd80\uc11c\ub294 \ud558\ub098 \uc774\uc0c1\uc758 \uc704\uce58\uc5d0 \uc18d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<br \/>\n\uc774 \uacbd\uc6b0 JOIN \ud45c\ud604\uc2dd\uc740 \"\ubd80\uc11c\" \ubc0f \"\uc704\uce58\" \uc720\ud615 \ubb38\uc11c\ub97c \uc870\uc778\ud558\uc5ec <code>\uc704\uce58<\/code> \ubc30\uc5f4 \uc18d\uc131\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubd80\uc11c \ubb38\uc11c\uc758 <code>\ubc30\uc5f4 \ud568\uc218<\/code> \ud45c\ud604\uc2dd\uc785\ub2c8\ub2e4.<\/p>\n<figure><img decoding=\"async\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2018\/02\/join_expression.png\" alt=\"\" \/><\/figure>\n<pre class=\"wrap:true lang:swift decode:true\">\/\/ \"department\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\n let departmentDS = DataSource.database(db).as(\"departmentDS\")\r\n\/\/ \"location\" \uc720\ud615 \ubb38\uc11c\uc758 \ub370\uc774\ud130 \uc18c\uc2a4\ub97c \ub098\ud0c0\ub0b4\ub294 \ubcc4\uce6d\uc744 \uc124\uc815\ud569\ub2c8\ub2e4.\r\nlet locationDS = DataSource.database(db).as(\"locationDS\")\r\n\r\n\/\/ \"\uc704\uce58\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd(\ubd80\uc11c \ubb38\uc11c\uc5d0\uc11c)\r\nlet departmentLocationExpr = Expression.property(\"location\").from(\"departmentDS\")\r\n\r\n\/\/ \"\ucf54\ub4dc\" \uc18d\uc131\uc5d0 \ub300\ud55c \uc18d\uc131 \ud45c\ud604\uc2dd (\uc704\uce58 \ubb38\uc11c\uc5d0\uc11c)\r\nlet locationCodeExpr = Expression.property(\"code\").from(\"locationDS\")\r\n\r\n\/\/ \uc704\uce58 \ubb38\uc11c\uc758 \"code\" \ud544\ub4dc\uac00 \ud3ec\ud568\ub41c \uc704\uce58\uc5d0 \uc870\uc778\ud569\ub2c8\ub2e4.\r\n\/\/ \"\ubd80\uc11c\" \ubb38\uc11c\uc758 \"\uc704\uce58\" \ubc30\uc5f4\uc5d0 \ud3ec\ud568\ub41c \uacf3\uc5d0 \uc870\uc778\ud569\ub2c8\ub2e4.\r\nlet joinDeptCodeExpr = ArrayFunction.contains(departmentLocationExpr, value: locationCodeExpr)\r\n    .and(Expression.property(\"type\").from(\"locationDS\").equalTo(Expression.string(\"location\"))\r\n    .and(Expression.property(\"type\").from(\"departmentDS\").equalTo(Expression.string(\"department\"))))))\r\n\r\n\/\/ \uc870\uc778 \ud45c\ud604\uc2dd\r\nlet joinLocationCode = Join.join(departmentDS).on(joinDeptCodeExpr)\r\n\r\n\/\/ JOIN\uc73c\ub85c \ucffc\ub9ac \uac80\uc0c9\r\nlet searchQuery = QueryBuilder.select(\r\nSelectResult.expression(Expression.property(\"name\").from(\"departmentDS\")).as(\"departmentName\"),\r\n    SelectResult.expression(Expression.property(\"name\").from(\"locationDS\")).as(\"locationName\"))\r\n    .from(locationDS)\r\n    .join(joinLocationCode)<\/pre>\n<p>&nbsp;<\/p>\n<h4>ANSI SQL<\/h4>\n<p>SQL\uc5d0\uc11c\ub294 \ubc30\uc5f4\uc774 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uadf8\ub7ec\ub098 N1QL\uc5d0\ub294 \ubc30\uc5f4\uc774 \uc9c0\uc6d0\ub429\ub2c8\ub2e4. \uc704 \ucffc\ub9ac\uc5d0 \ud574\ub2f9\ud558\ub294 SQL\uacfc \uc720\uc0ac\ud55c \ubb38\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<pre class=\"wrap:true lang:mysql decode:true\">SELECT\r\n  departmentDS.name AS departmentName,\r\n  locationDS.name AS locationName\r\nFROM\r\n  `travel-sample` locationDS\r\n  JOIN `travel-sample` departmentDS ON\r\n    ANY code IN departmentDS.location SATISFIES code = locationDS.location\r\n    END\r\n  \r\nWHERE\r\n  departmentDS.type = \"department\"\r\n  AND locationDS.type = \"location\"<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"whatnext\">\ub2e4\uc74c \ub2e8\uacc4<\/h3>\n<p>\uc774 \ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 \uc5ec\ub7ec JSON \ubb38\uc11c\uc758 \uacb0\uacfc\ub97c \uacb0\ud569\ud560 \uc218 \uc788\ub294 Couchbase Mobile 2.0\uc758 \uac15\ub825\ud55c JOIN \uae30\ub2a5\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubd05\ub2c8\ub2e4. \ub2e4\uc74c\uc744 \uc218\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/downloads\/\">\ub2e4\uc6b4\ub85c\ub4dc<\/a> \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubaa8\ubc14\uc77c 2.0\uc744 \uc124\uce58\ud558\uace0 \uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c \uc124\uba85\ud55c \ucffc\ub9ac\ub97c \ud14c\uc2a4\ud2b8\ud574 \ubcf4\uc138\uc694. \uc774\uac83\uc740 \uc2dc\uc791\uc5d0 \ubd88\uacfc\ud569\ub2c8\ub2e4. \ud5a5\ud6c4 \ub9b4\ub9ac\uc2a4\uc5d0\uc11c \ub354 \ub9ce\uc740 \uae30\ub2a5\uc774 \ucd94\uac00\ub420 \uc608\uc815\uc785\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c\uc740 \uad00\uc2ec\uc744 \uac00\uc9c8 \ub9cc\ud55c \uba87 \uac00\uc9c0 \ub2e4\ub978 Couchbase \ubaa8\ubc14\uc77c \ucffc\ub9ac \uad00\ub828 \uac8c\uc2dc\ubb3c\uc785\ub2c8\ub2e4.<br \/>\n- \uc774 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/sql-for-json-query-interface-couchbase-mobile\/\">\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c<\/a> \uae30\ubcf8 \uc0ac\ud56d\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<br \/>\n- \uc774 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/querying-array-collections-couchbase-mobile\/\">\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c<\/a> \ubc30\uc5f4 \uceec\ub809\uc158\uc744 \ucffc\ub9ac\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<br \/>\n- \uc774 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/full-text-search-couchbase-mobile-2-0\/\">\ube14\ub85c\uadf8 \uac8c\uc2dc\ubb3c<\/a> \uc5d0\uc11c\ub294 \uc804\uccb4 \ud14d\uc2a4\ud2b8 \uac80\uc0c9(FTS) \uae30\ub2a5\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc9c8\ubb38\uc774\ub098 \ud53c\ub4dc\ubc31\uc774 \uc788\uc73c\uba74 \uc544\ub798\uc5d0 \ub313\uae00\uc744 \ub0a8\uae30\uac70\ub098 \ud2b8\uc704\ud130\ub85c \uc5b8\uc81c\ub4e0\uc9c0 \ubb38\uc758\ud574 \uc8fc\uc138\uc694.\u00a0<a href=\"https:\/\/twitter.com\/rajagp\">@rajagp<\/a>\u00a0\ub610\ub294 \uc774\uba54\uc77c\uc744 \ubcf4\ub0b4\uc8fc\uc138\uc694.\u00a0<a href=\"mailto:priya.rajagopal@couchbase.com\">priya.rajagopal@couchbase.com<\/a>.  .\u00a0<a href=\"https:\/\/www.couchbase.com\/blog\/ko\/forums\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ud3ec\ub7fc<\/a> \ub97c \ud1b5\ud574 \uc9c8\ubb38\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>","protected":false},"excerpt":{"rendered":"<p>Couchbase Lite 2.0\uc740 JSON \ubb38\uc11c\uc5d0\uc11c JOIN\uc744 \uc218\ud589\ud560 \uc218 \uc788\ub294 \uae30\ub2a5\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\ub294 JSON\uc6a9 SQL\uc744 \ud655\uc7a5\ud558\ub294 Couchbase\uc758 \uc120\uc5b8\uc801 \ucffc\ub9ac \uc5b8\uc5b4\uc778 N1QL\uc5d0 \uae30\ubc18\ud55c \uc0c8\ub85c\uc6b4 \ucffc\ub9ac \uc778\ud130\ud398\uc774\uc2a4\uc758 \uc77c\ubd80\uc785\ub2c8\ub2e4. SQL\uc5d0 \uc775\uc219\ud55c \uacbd\uc6b0 [...]<\/p>","protected":false},"author":1423,"featured_media":4586,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,7667,1810,1812],"tags":[2004],"ppma_author":[8948],"class_list":["post-4498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-couchbase-lite","category-couchbase-mobile","category-n1ql-query","tag-couchbase-mobile-2-0"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.4 (Yoast SEO v26.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introducing JOIN Queries in Couchbase Mobile - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"This post discusses how you can JOIN JSON documents in Couchbase Mobile. This capability allows you to combine the contents of multiple JSON documents.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/join-queries-couchbase-mobile\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introducing JOIN Queries in Couchbase Mobile\" \/>\n<meta property=\"og:description\" content=\"This post discusses how you can JOIN JSON documents in Couchbase Mobile. This capability allows you to combine the contents of multiple JSON documents.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/join-queries-couchbase-mobile\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-12T18:00:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T03:09:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png\" \/>\n\t<meta property=\"og:image:width\" content=\"722\" \/>\n\t<meta property=\"og:image:height\" content=\"483\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Priya Rajagopal, Senior Director, Product Management\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rajagp\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Priya Rajagopal, Senior Director, Product Management\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/\"},\"author\":{\"name\":\"Priya Rajagopal, Senior Director, Product Management\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c2da90e57717ee4970c48a87a131ac2c\"},\"headline\":\"Introducing JOIN Queries in Couchbase Mobile\",\"datePublished\":\"2018-02-12T18:00:54+00:00\",\"dateModified\":\"2025-06-14T03:09:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/\"},\"wordCount\":1438,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png\",\"keywords\":[\"couchbase mobile 2.0\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Lite\",\"Couchbase Mobile\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/\",\"name\":\"Introducing JOIN Queries in Couchbase Mobile - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png\",\"datePublished\":\"2018-02-12T18:00:54+00:00\",\"dateModified\":\"2025-06-14T03:09:22+00:00\",\"description\":\"This post discusses how you can JOIN JSON documents in Couchbase Mobile. This capability allows you to combine the contents of multiple JSON documents.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png\",\"width\":722,\"height\":483,\"caption\":\"join on array\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introducing JOIN Queries in Couchbase Mobile\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c2da90e57717ee4970c48a87a131ac2c\",\"name\":\"Priya Rajagopal, Senior Director, Product Management\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4b50a54778b979d8c345b036ab138734\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/acfb2349788955262cd069497a9e7bdb0e97c26326f2e55811e7c1174e9ef1be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/acfb2349788955262cd069497a9e7bdb0e97c26326f2e55811e7c1174e9ef1be?s=96&d=mm&r=g\",\"caption\":\"Priya Rajagopal, Senior Director, Product Management\"},\"description\":\"Priya Rajagopal is a Senior Director of Product Management at Couchbase responsible for developer platforms for the cloud and the edge. She has been professionally developing software for over 20 years in several technical and product leadership positions, with 10+ years focused on mobile technologies. As a TISPAN IPTV standards delegate, she was a key contributor to the IPTV standards specifications. She has 22 patents in the areas of networking and platform security.\",\"sameAs\":[\"https:\/\/x.com\/rajagp\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/priya-rajagopalcouchbase-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubaa8\ubc14\uc77c\uc758 JOIN \ucffc\ub9ac \uc18c\uac1c - \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"\uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 Couchbase Mobile\uc5d0\uc11c JSON \ubb38\uc11c\ub97c \uc870\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec JSON \ubb38\uc11c\uc758 \ub0b4\uc6a9\uc744 \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/join-queries-couchbase-mobile\/","og_locale":"ko_KR","og_type":"article","og_title":"Introducing JOIN Queries in Couchbase Mobile","og_description":"This post discusses how you can JOIN JSON documents in Couchbase Mobile. This capability allows you to combine the contents of multiple JSON documents.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/join-queries-couchbase-mobile\/","og_site_name":"The Couchbase Blog","article_published_time":"2018-02-12T18:00:54+00:00","article_modified_time":"2025-06-14T03:09:22+00:00","og_image":[{"width":722,"height":483,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png","type":"image\/png"}],"author":"Priya Rajagopal, Senior Director, Product Management","twitter_card":"summary_large_image","twitter_creator":"@rajagp","twitter_misc":{"Written by":"Priya Rajagopal, Senior Director, Product Management","Est. reading time":"12\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/"},"author":{"name":"Priya Rajagopal, Senior Director, Product Management","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c2da90e57717ee4970c48a87a131ac2c"},"headline":"Introducing JOIN Queries in Couchbase Mobile","datePublished":"2018-02-12T18:00:54+00:00","dateModified":"2025-06-14T03:09:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/"},"wordCount":1438,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png","keywords":["couchbase mobile 2.0"],"articleSection":["Best Practices and Tutorials","Couchbase Lite","Couchbase Mobile","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/","url":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ubaa8\ubc14\uc77c\uc758 JOIN \ucffc\ub9ac \uc18c\uac1c - \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png","datePublished":"2018-02-12T18:00:54+00:00","dateModified":"2025-06-14T03:09:22+00:00","description":"\uc774 \uac8c\uc2dc\ubb3c\uc5d0\uc11c\ub294 Couchbase Mobile\uc5d0\uc11c JSON \ubb38\uc11c\ub97c \uc870\uc778\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574 \uc124\uba85\ud569\ub2c8\ub2e4. \uc774 \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\uba74 \uc5ec\ub7ec JSON \ubb38\uc11c\uc758 \ub0b4\uc6a9\uc744 \uacb0\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2018\/02\/join_expression.png","width":722,"height":483,"caption":"join on array"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/join-queries-couchbase-mobile\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Introducing JOIN Queries in Couchbase Mobile"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/c2da90e57717ee4970c48a87a131ac2c","name":"\ud504\ub9ac\uc57c \ub77c\uc790\uace0\ud314, \uc81c\ud488 \uad00\ub9ac \ubd80\ubb38 \uc120\uc784 \uc774\uc0ac","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/4b50a54778b979d8c345b036ab138734","url":"https:\/\/secure.gravatar.com\/avatar\/acfb2349788955262cd069497a9e7bdb0e97c26326f2e55811e7c1174e9ef1be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/acfb2349788955262cd069497a9e7bdb0e97c26326f2e55811e7c1174e9ef1be?s=96&d=mm&r=g","caption":"Priya Rajagopal, Senior Director, Product Management"},"description":"\ud504\ub9ac\uc57c \ub77c\uc790\uace0\ud314\uc740 \ud074\ub77c\uc6b0\ub4dc \ubc0f \uc5e3\uc9c0\uc6a9 \uac1c\ubc1c\uc790 \ud50c\ub7ab\ud3fc\uc744 \ub2f4\ub2f9\ud558\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \uc218\uc11d \uc774\uc0ac\uc785\ub2c8\ub2e4. \uadf8\ub140\ub294 20\ub144 \uc774\uc0c1 \uc5ec\ub7ec \uae30\uc220 \ubc0f \uc81c\ud488 \ub9ac\ub354\uc2ed \uc9c1\ucc45\uc744 \ub9e1\uc73c\uba70 \uc804\ubb38\uc801\uc73c\ub85c \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \uac1c\ubc1c\ud574 \uc654\uc73c\uba70, \uadf8\uc911 10\ub144 \uc774\uc0c1\uc740 \ubaa8\ubc14\uc77c \uae30\uc220\uc5d0 \uc9d1\uc911\ud588\uc2b5\ub2c8\ub2e4. TISPAN IPTV \ud45c\uc900 \ub300\ud45c\ub85c\uc11c IPTV \ud45c\uc900 \uc0ac\uc591\uc5d0 \ud575\uc2ec\uc801\uc778 \uae30\uc5ec\ub97c \ud588\uc2b5\ub2c8\ub2e4. \ub124\ud2b8\uc6cc\ud0b9 \ubc0f \ud50c\ub7ab\ud3fc \ubcf4\uc548 \ubd84\uc57c\uc5d0\uc11c 22\uac1c\uc758 \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.","sameAs":["https:\/\/x.com\/rajagp"],"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/priya-rajagopalcouchbase-com\/"}]}},"authors":[{"term_id":8948,"user_id":1423,"is_guest":0,"slug":"priya-rajagopalcouchbase-com","display_name":"Priya Rajagopal, Senior Director, Product Management","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/acfb2349788955262cd069497a9e7bdb0e97c26326f2e55811e7c1174e9ef1be?s=96&d=mm&r=g","author_category":"","last_name":"Rajagopal, Senior Director, Product Management","first_name":"Priya","job_title":"","user_url":"","description":"\ud504\ub9ac\uc57c \ub77c\uc790\uace0\ud314\uc740 \ud074\ub77c\uc6b0\ub4dc \ubc0f \uc5e3\uc9c0\uc6a9 \uac1c\ubc1c\uc790 \ud50c\ub7ab\ud3fc\uc744 \ub2f4\ub2f9\ud558\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \uc218\uc11d \uc774\uc0ac\uc785\ub2c8\ub2e4. \uadf8\ub140\ub294 20\ub144 \uc774\uc0c1 \uc5ec\ub7ec \uae30\uc220 \ubc0f \uc81c\ud488 \ub9ac\ub354\uc2ed \uc9c1\ucc45\uc744 \ub9e1\uc73c\uba70 \uc804\ubb38\uc801\uc73c\ub85c \uc18c\ud504\ud2b8\uc6e8\uc5b4\ub97c \uac1c\ubc1c\ud574 \uc654\uc73c\uba70, \uadf8\uc911 10\ub144 \uc774\uc0c1\uc740 \ubaa8\ubc14\uc77c \uae30\uc220\uc5d0 \uc9d1\uc911\ud588\uc2b5\ub2c8\ub2e4. TISPAN IPTV \ud45c\uc900 \ub300\ud45c\ub85c\uc11c IPTV \ud45c\uc900 \uc0ac\uc591\uc5d0 \ud575\uc2ec\uc801\uc778 \uae30\uc5ec\ub97c \ud588\uc2b5\ub2c8\ub2e4. \ub124\ud2b8\uc6cc\ud0b9 \ubc0f \ud50c\ub7ab\ud3fc \ubcf4\uc548 \ubd84\uc57c\uc5d0\uc11c 22\uac1c\uc758 \ud2b9\ud5c8\ub97c \ubcf4\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/1423"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=4498"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/4586"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=4498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=4498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=4498"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=4498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}