{"id":3400,"date":"2016-07-25T10:00:23","date_gmt":"2016-07-25T10:00:23","guid":{"rendered":"https:\/\/kiencang.net\/?p=3400"},"modified":"2016-07-25T10:00:23","modified_gmt":"2016-07-25T10:00:23","slug":"cac-kieu-sql-join","status":"publish","type":"post","link":"https:\/\/kiencang.net\/cac-kieu-sql-join\/","title":{"rendered":"C\u00e1c ki\u1ec3u SQL Join"},"content":{"rendered":"\n

M\u1ed9t m\u1ec7nh \u0111\u1ec1 SQL JOIN<\/code> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0ng t\u1eeb hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng, d\u1ef1a tr\u00ean m\u1ed9t tr\u01b0\u1eddng chung gi\u1eefa ch\u00fang.<\/p>\n\n\n\n

M\u1ed9t ki\u1ec3u n\u1ed1i ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0: SQL INNER JOIN (n\u1ed1i \u0111\u01a1n gi\u1ea3n)<\/strong>. SQL INNER JOIN<\/code> tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb nhi\u1ec1u b\u1ea3ng n\u01a1i \u0111i\u1ec1u ki\u1ec7n n\u1ed1i g\u1eb7p g\u1ee1 nhau.<\/p>\n\n\n\n

C\u00f9ng quan s\u00e1t m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Orders”:<\/p>\n\n\n\n

OrderID<\/th>CustomerID<\/th>OrderDate<\/th><\/tr>
10308<\/td>2<\/td>1996-09-18<\/td><\/tr>
10309<\/td>37<\/td>1996-09-19<\/td><\/tr>
10310<\/td>77<\/td>1996-09-20<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Ti\u1ebfp \u0111\u00f3, ta nh\u00ecn ti\u1ebfp v\u00e0o m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”:<\/p>\n\n\n\n

CustomerID<\/th>CustomerName<\/th>ContactName<\/th>Country<\/th><\/tr>
1<\/td>Alfreds Futterkiste<\/td>Maria Anders<\/td>Germany<\/td><\/tr>
2<\/td>Ana Trujillo Emparedados y helados<\/td>Ana Trujillo<\/td>Mexico<\/td><\/tr>
3<\/td>Antonio Moreno Taquer\u00eda<\/td>Antonio Moreno<\/td>Mexico<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

L\u01b0u \u00fd c\u1ed9t “CustomerID” trong b\u1ea3ng “Orders” vi\u1ec7n d\u1eabn t\u1eeb “CustomerID” trong b\u1ea3ng “Customers”. M\u1ed1i quan h\u1ec7 gi\u1eefa hai b\u1ea3ng tr\u00ean l\u00e0 c\u1ed9t “CustomerID”.<\/p>\n\n\n\n

Sau \u0111\u00f3, n\u1ebfu ch\u00fang ta ch\u1ea1y c\u00e2u l\u1ec7nh SQL sau (bao g\u1ed3m INNER JOIN<\/code>).<\/p>\n\n\n\n

V\u00ed d\u1ee5:<\/h3>\n\n\n\n
SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate\nFROM Orders\nINNER JOIN Customers\nON Orders.CustomerID=Customers.CustomerID;<\/code><\/pre>\n\n\n\n
N\u00f3 s\u1ebd t\u1ea1o ra b\u1ea3ng ki\u1ec3u nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n
OrderID<\/th>CustomerName<\/th>OrderDate<\/th><\/tr>
10308<\/td>Ana Trujillo Emparedados y helados<\/td>9\/18\/1996<\/td><\/tr>
10365<\/td>Antonio Moreno Taquer\u00eda<\/td>11\/27\/1996<\/td><\/tr>
10383<\/td>Around the Horn<\/td>12\/16\/1996<\/td><\/tr>
10355<\/td>Around the Horn<\/td>11\/15\/1996<\/td><\/tr>
10278<\/td>Berglunds snabbk\u00f6p<\/td>8\/12\/1996<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
C\u00e1c ki\u1ec3u SQL JOIN<\/h2>\n\n\n\n
Tr\u01b0\u1edbc khi ch\u00fang ta ti\u1ebfp t\u1ee5c v\u1edbi c\u00e1c v\u00ed d\u1ee5, ch\u00fang ta s\u1ebd li\u1ec7t k\u00ea c\u00e1c ki\u1ec3u SQL JOIN b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng:<\/p>\n\n\n\n
  • INNER JOIN<\/b>: Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng khi c\u00f3 \u00edt nh\u1ea5t m\u1ed9t s\u1ef1 ph\u00f9 h\u1ee3p trong C\u1ea2 HAI b\u1ea3ng<\/li>
  • LEFT JOIN<\/b>: Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb b\u1ea3ng tr\u00e1i, v\u00e0 c\u00e1c h\u00e0ng ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng ph\u1ea3i<\/li>
  • RIGHT JOIN<\/b>: Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb b\u1ea3ng ph\u1ea3i, v\u00e0 c\u00e1c h\u00e0ng ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng tr\u00e1i<\/li>
  • FULL JOIN<\/b>: Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng khi c\u00f3 m\u1ed9t \u0111i\u1ec1u ph\u00f9 h\u1ee3p trong M\u1ed8T c\u1ee7a c\u00e1c b\u1ea3ng<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"
    M\u1ed9t m\u1ec7nh \u0111\u1ec1 SQL JOIN \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0ng t\u1eeb hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng, d\u1ef1a tr\u00ean m\u1ed9t tr\u01b0\u1eddng chung gi\u1eefa ch\u00fang. M\u1ed9t ki\u1ec3u n\u1ed1i ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0: SQL INNER JOIN (n\u1ed1i \u0111\u01a1n gi\u1ea3n). SQL INNER JOIN tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb nhi\u1ec1u b\u1ea3ng n\u01a1i \u0111i\u1ec1u ki\u1ec7n n\u1ed1i g\u1eb7p g\u1ee1 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[239],"tags":[],"yoast_head":"\nC\u00e1c ki\u1ec3u SQL Join • Ki\u1ebfn c\u00e0ng<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kiencang.net\/cac-kieu-sql-join\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c ki\u1ec3u SQL Join • Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"M\u1ed9t m\u1ec7nh \u0111\u1ec1 SQL JOIN \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0ng t\u1eeb hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng, d\u1ef1a tr\u00ean m\u1ed9t tr\u01b0\u1eddng chung gi\u1eefa ch\u00fang. M\u1ed9t ki\u1ec3u n\u1ed1i ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0: SQL INNER JOIN (n\u1ed1i \u0111\u01a1n gi\u1ea3n). SQL INNER JOIN tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb nhi\u1ec1u b\u1ea3ng n\u01a1i \u0111i\u1ec1u ki\u1ec7n n\u1ed1i g\u1eb7p g\u1ee1 …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/cac-kieu-sql-join\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-25T10:00:23+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1c ki\u1ec3u SQL Join • Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/cac-kieu-sql-join\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c ki\u1ec3u SQL Join • Ki\u1ebfn c\u00e0ng","og_description":"M\u1ed9t m\u1ec7nh \u0111\u1ec1 SQL JOIN \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c h\u00e0ng t\u1eeb hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng, d\u1ef1a tr\u00ean m\u1ed9t tr\u01b0\u1eddng chung gi\u1eefa ch\u00fang. M\u1ed9t ki\u1ec3u n\u1ed1i ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0: SQL INNER JOIN (n\u1ed1i \u0111\u01a1n gi\u1ea3n). SQL INNER JOIN tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng t\u1eeb nhi\u1ec1u b\u1ea3ng n\u01a1i \u0111i\u1ec1u ki\u1ec7n n\u1ed1i g\u1eb7p g\u1ee1 …","og_url":"https:\/\/kiencang.net\/cac-kieu-sql-join\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-25T10:00:23+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/cac-kieu-sql-join\/","url":"https:\/\/kiencang.net\/cac-kieu-sql-join\/","name":"C\u00e1c ki\u1ec3u SQL Join • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-25T10:00:23+00:00","dateModified":"2016-07-25T10:00:23+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/cac-kieu-sql-join\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/cac-kieu-sql-join\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/cac-kieu-sql-join\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"C\u00e1c ki\u1ec3u SQL Join"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3400"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3400"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3400\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}