{"id":3873,"date":"2024-12-03T14:34:55","date_gmt":"2024-12-03T14:34:55","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/noi-du-lieu-trong-bang-su-dung-sql-excel\/"},"modified":"2024-12-03T14:34:55","modified_gmt":"2024-12-03T14:34:55","slug":"noi-du-lieu-trong-bang-su-dung-sql-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/noi-du-lieu-trong-bang-su-dung-sql-excel\/","title":{"rendered":"N\u1ed1i d\u1eef li\u1ec7u trong b\u1ea3ng s\u1eed d\u1ee5ng SQL Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em>C\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft vi\u1ec7c k\u1ebft h\u1ee3p hai b\u1ea3ng t\u00ednh l\u1ea1i v\u1edbi nhau d\u1ef1a v\u00e0o c\u1ed9t n\u00e0o \u0111\u00f3 c\u1ef1c k\u1ef3 quan tr\u1ecdng, v\u1eady l\u00e0m sao \u0111\u1ec3 t\u1ed5ng h\u1ee3p ch\u00fang l\u1ea1i v\u1edbi nhau theo \u0111i\u1ec1u ki\u1ec7n l\u1ecdc \u0111\u00f3, h\u00e3y theo d\u00f5i b\u00e0i vi\u1ebft sau \u0111\u00e2y \u0111\u1ec3 bi\u1ebft th\u00eam nh\u1eefng \u0111i\u1ec1u th\u00fa v\u1ecb v\u1ec1 <a href=\"http:\/\/blog.ezworkapp.com\/noi-du-lieu-trong-hai-bang-su-dung-sql.html\"><strong>s\u1eed d\u1ee5ng SQL Excel<\/strong><\/a> t\u1ea1i <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> nh\u00e9.<\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674f170ea6ed3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Yeu_cau\" title=\"Y\u00eau c\u1ea7u\">Y\u00eau c\u1ea7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Gioi_thieu_ve_cau_lenh_JOIN_trong_su_dung_SQL_Excel\" title=\"Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e2u l\u1ec7nh JOIN trong s\u1eed d\u1ee5ng SQL Excel\">Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e2u l\u1ec7nh JOIN trong s\u1eed d\u1ee5ng SQL Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Tu_khoa_%E2%80%9CINNER_JOIN%E2%80%9D\" title=\"T\u1eeb kh\u00f3a \u201cINNER JOIN\u201d\">T\u1eeb kh\u00f3a \u201cINNER JOIN\u201d<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Y_nghia\" title=\"\u00dd ngh\u0129a\">\u00dd ngh\u0129a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Cu_Phap\" title=\"C\u00fa Ph\u00e1p\">C\u00fa Ph\u00e1p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Tu_khoa_%E2%80%9CLEFT_JOIN%E2%80%9D_trong_su_dung_SQL_Excel\" title=\"T\u1eeb kh\u00f3a \u201cLEFT JOIN\u201d trong s\u1eed d\u1ee5ng SQL Excel\">T\u1eeb kh\u00f3a \u201cLEFT JOIN\u201d trong s\u1eed d\u1ee5ng SQL Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Y_nghia-2\" title=\"\u00dd ngh\u0129a\">\u00dd ngh\u0129a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Cu_Phap-2\" title=\"C\u00fa Ph\u00e1p\">C\u00fa Ph\u00e1p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Tu_khoa_%E2%80%9CRIGHT_JOIN%E2%80%9D\" title=\"T\u1eeb kh\u00f3a \u201cRIGHT\u00a0 JOIN\u201d\">T\u1eeb kh\u00f3a \u201cRIGHT\u00a0 JOIN\u201d<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Y_nghia-3\" title=\"\u00dd ngh\u0129a\">\u00dd ngh\u0129a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Cu_phap\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Ket_hop_tu_khoa_tao_ra_FULL_JOIN\" title=\"K\u1ebft h\u1ee3p t\u1eeb kh\u00f3a t\u1ea1o ra FULL JOIN\">K\u1ebft h\u1ee3p t\u1eeb kh\u00f3a t\u1ea1o ra FULL JOIN<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Y_nghia-4\" title=\"\u00dd ngh\u0129a\">\u00dd ngh\u0129a<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Cu_phap-2\" title=\"C\u00fa ph\u00e1p\">C\u00fa ph\u00e1p<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#_Cac_cau_truy_van_su_dung\" title=\"\u00a0C\u00e1c c\u00e2u truy v\u1ea5n s\u1eed d\u1ee5ng\">\u00a0C\u00e1c c\u00e2u truy v\u1ea5n s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/noi-du-lieu-trong-hai-bang-su-dung-sql.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Yeu_cau\"><\/span>Y\u00eau c\u1ea7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft code tr\u00ean vba c\u00e1c b\u1ea1n h\u00e3y t\u1ea3i v\u1ec1 v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"><strong>c\u00e0i \u0111\u1eb7t Add ins-HocExcelOnline<\/strong> <\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Gioi_thieu_ve_cau_lenh_JOIN_trong_su_dung_SQL_Excel\"><\/span>Gi\u1edbi thi\u1ec7u v\u1ec1 c\u00e2u l\u1ec7nh JOIN trong s\u1eed d\u1ee5ng SQL Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30861\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/joinsql.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-1\" width=\"513\" height=\"117\" title=\"joinsql\"><\/p>\n<p>Ta c\u00f3 b\u1ea3ng d\u1eef li\u1ec7u nh\u00e2n s\u1ef1 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30887 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vidu.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-2\" width=\"899\" height=\"407\" title=\"vidu\"><\/p>\n<p>\u00a0<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tu_khoa_%E2%80%9CINNER_JOIN%E2%80%9D\"><\/span>T\u1eeb kh\u00f3a \u201cINNER JOIN\u201d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Y_nghia\"><\/span>\u00dd ngh\u0129a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb kh\u00f3a \u201c<strong>INNER JOIN<\/strong>\u201d tr\u1ea3 ra t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi c\u00f3 gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p.<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-307.gif\" title=\"ex101_92019-nho-307\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-131.gif\" title=\"vba101_92019-nho-131\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-307.gif\" title=\"ex101_92019-nho-307\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ngh\u0129a l\u00e0 trong b\u1ea3ng 1 v\u00e0 b\u1ea3ng 2 ph\u1ea3i c\u00f3 chung m\u1ed9t \u0111i\u1ec3m \u1edf v\u00ed d\u1ee5 tr\u00ean l\u00e0 [M\u00e3 nh\u00e2n vi\u00ean] s\u1ebd l\u00e0 \u0111i\u1ec3m trung gi\u1eefa hai b\u1ea3ng d\u1eef li\u1ec7u s\u1ebd lo\u1ea1i b\u1ecf \u0111i c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng tr\u00f9ng nhau gi\u1eefa c\u1ed9t [M\u00e3 nh\u00e2n vi\u00ean].<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30900 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/inner-join.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-3\" width=\"1569\" height=\"510\" title=\"inner-join\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_Phap\"><\/span>C\u00fa Ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>\u00a0SELECT bang1.[cot1], bang2.[cot1]\u2026 FROM bang1 INNER JOIN bang2 On bang1.[cotloc] = bang2.[cotloc]<\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Tu_khoa_%E2%80%9CLEFT_JOIN%E2%80%9D_trong_su_dung_SQL_Excel\"><\/span>T\u1eeb kh\u00f3a \u201cLEFT JOIN\u201d trong s\u1eed d\u1ee5ng SQL Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Y_nghia-2\"><\/span>\u00dd ngh\u0129a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb kh\u00f3a \u201c<strong>LEFT\u00a0JOIN<\/strong>\u201d\u00a0Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i v\u00e0 c\u00e1c b\u1ea3n ghi ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng b\u00ean ph\u1ea3i b\u1ea3ng ghi b\u00ean ph\u1ea3i kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u s\u1ebd tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p>L\u1ea5y to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb\u00a0b\u00ean tr\u00e1i c\u1ee7a bang1\u00a0v\u00e0 c\u00e1c\u00a0b\u1ea3ng ghi b\u00ean ph\u1ea3i b\u1ea3ng 2\u00a0ghi ph\u00f9 h\u1ee3p b\u00ean ph\u1ea3i n\u1ebfu b\u1ea3ng2 kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30879 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/lefjoinexcel.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-4\" width=\"1580\" height=\"386\" title=\"lefjoinexcel\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_Phap-2\"><\/span>C\u00fa Ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT bang1.[cot1], bang2.[cot1]\u2026 FROM bang1 LEFT JOIN bang2 On bang1.[cotloc] = bang2.[cotloc]<\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Tu_khoa_%E2%80%9CRIGHT_JOIN%E2%80%9D\"><\/span>T\u1eeb kh\u00f3a \u201cRIGHT\u00a0 JOIN\u201d<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Y_nghia-3\"><\/span>\u00dd ngh\u0129a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u1eeb kh\u00f3a \u201c<strong>RIGHT\u00a0JOIN<\/strong>\u201d\u00a0Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi t\u1eeb b\u1ea3ng b\u00ean ph\u1ea3i v\u00e0 c\u00e1c b\u1ea3n ghi ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i b\u1ea3ng ghi b\u00ean tr\u00e1i kh\u00f4ng c\u00f3 s\u1ebd tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p>Ng\u01b0\u1ee3c v\u1edbi LEFT JOIN t\u1eeb kh\u00f3a RIGHT JOIN s\u1ebd l\u1ea5y t\u1ea5t [M\u00e3 nh\u00e2n vi\u00ean] \u1edf b\u1ea3ng 2 v\u00e0 c\u00e1c b\u1ea3ng ghi ph\u00f9 h\u1ee3p b\u1ea3ng 1 n\u1ebfu b\u1ea3ng 1 kh\u00f4ng c\u00f3 tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30880 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/right-join.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-5\" width=\"1583\" height=\"381\" title=\"right-join\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT bang1.[cot1], bang2.[cot1]\u2026 FROM bang1 RIGHT JOIN bang2 On bang1.[cotloc] = bang2.[cotloc]<\/strong><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Ket_hop_tu_khoa_tao_ra_FULL_JOIN\"><\/span>K\u1ebft h\u1ee3p t\u1eeb kh\u00f3a t\u1ea1o ra FULL JOIN<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>K\u1ebft h\u1ee3p gi\u1eefa hai b\u1ea3ng l\u1ea5y ra t\u1ea5t c\u1ea3 hai b\u1ea3ng ph\u1ea3i l\u00e0m sao b\u00e2y gi\u1edd khi Excel l\u1ea1i kh\u00f4ng h\u1ed7 tr\u1ee3 FULL JOIN ta ph\u1ea3i l\u00e0m sao b\u00e2y gi\u1edd \u0111\u1eebng lo l\u1eafng nh\u00e9, ta s\u1ebd k\u1ebft h\u1ee3p \u201cLEFT JOIN\u201d v\u1edbi \u201cRIGHT JOIN\u201d v\u00e0 t\u1eeb kh\u00f3a \u201cUNION\u201d l\u00e0 ra th\u00f4i m\u00e0<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Y_nghia-4\"><\/span>\u00dd ngh\u0129a<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>L\u1ea5y ra to\u00e0n b\u1ed9 s\u1ed1 b\u1ea3n ghi gi\u1eefa hai b\u1ea3ng<\/p>\n<p>\u1edf \u0111\u00e2y ta mu\u1ed1n l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi \u1edf hai b\u1ea3ng n\u00ean s\u1ebd s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p hai t\u1eeb kh\u00f3a LEFT JOIN v\u00e0 RIGHT \u0111\u1ec3 t\u1ea1o ra k\u1ebft qu\u1ea3 do excel kh\u00f4ng h\u1ed7 tr\u1ee3 FULL JOIN.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30886 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/fulljoin.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-6\" width=\"1551\" height=\"398\" title=\"fulljoin\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap-2\"><\/span>C\u00fa ph\u00e1p<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT bang1.[cot1], bang2.[cot1]\u2026 FROM bang1 LEFT\u00a0JOIN bang2 On bang1.[cotloc] = bang2.[cotloc] UNION\u00a0SELECT bang1.[cot1], bang2.[cot1]\u2026 FROM bang1 RIGHT JOIN bang2 On bang1.[cotloc] = bang2.[cotloc]<\/strong><\/p>\n<\/blockquote>\n<p>L\u1ea5y\u00a0 ra t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi c\u00f3 gi\u00e1 tr\u1ecb ph\u00f9 h\u1ee3p \u201cINNER JOIN\u201d<\/p>\n<h2><span class=\"ez-toc-section\" id=\"_Cac_cau_truy_van_su_dung\"><\/span>\u00a0C\u00e1c c\u00e2u truy v\u1ea5n s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i v\u00e0 c\u00e1c b\u1ea3n ghi ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng b\u00ean ph\u1ea3i b\u1ea3ng ghi b\u00ean ph\u1ea3i kh\u00f4ng c\u00f3 d\u1eef li\u1ec7u s\u1ebd tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng t\u1eeb kh\u00f3a \u201cLEFT JOIN\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30889 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/left-join.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-7\" width=\"1573\" height=\"519\" title=\"left-join\"><\/p>\n<p>Tr\u1ea3 v\u1ec1 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi t\u1eeb b\u1ea3ng b\u00ean ph\u1ea3i v\u00e0 c\u00e1c b\u1ea3n ghi ph\u00f9 h\u1ee3p t\u1eeb b\u1ea3ng b\u00ean tr\u00e1i b\u1ea3ng ghi b\u00ean tr\u00e1i kh\u00f4ng c\u00f3 s\u1ebd tr\u1ea3 ra gi\u00e1 tr\u1ecb r\u1ed7ng t\u1eeb kh\u00f3a \u201cRIGHT JOIN\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30890 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/right-join-1.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-8\" width=\"1569\" height=\"513\" title=\"right-join-1\"><\/p>\n<p>L\u1ea5y ra to\u00e0n b\u1ed9 d\u1eef li\u1ec7u gi\u1eefa hai b\u1ea3ng t\u00ednh.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30892 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/full-join-1.png\" alt=\"noi-du-lieu-trong-bang-su-dung-SQL-excel-9\" width=\"1666\" height=\"658\" title=\"full-join-1\"><\/p>\n<p>\u0110\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 SQL c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o nh\u1eefng <strong><a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\">kh\u00f3a h\u1ecdc c\u1ee7a VBA Excel<\/a> <\/strong>\u0111\u1ec3 t\u00ecm hi\u1ec3u k\u1ef9 h\u01a1n v\u1ec1 s\u1ef1 linh \u0111\u1ed9ng n\u00e0y.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft tr\u00ean HocExcelOnline hy v\u1ecdng c\u00e1c b\u1ea1n v\u1eadn d\u1ee5ng c\u00e1c lo\u1ea1i \u201cJOIN\u201d m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 t\u1ea1o ra nh\u1eefng b\u1ea3ng b\u00e1o c\u00e1o nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00e1ch <strong>s\u1eed d\u1ee5ng SQL Excel<\/strong> kh\u00e1 hay.<\/p>\n<p>N\u1ebfu th\u1ea5y hay h\u00e3y \u1ee7ng h\u1ed9, chia s\u1ebb b\u00e0i vi\u1ebft \u0111\u1ec3 nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn v\u00e0 <strong>Hoc Excel Online<\/strong> c\u00f3 \u0111\u1ed9ng l\u1ef1c \u0111\u1ec3 ph\u00e1t tri\u1ec3n b\u00e0i vi\u1ebft t\u1ed1t h\u01a1n.<\/p>\n<hr>\n<div class=\"breadcrumb\"><a href=\"http:\/\/blog.ezworkapp.com\/tach-gmail-chu-ra-khoi-chuoi-su-dung-add-ins-hocexcel-online.html\">T\u00e1ch Gmail, s\u1ed1, ch\u1eef ra kh\u1ecfi chu\u1ed7i s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/div>\n<div class=\"post-single-content box mark-links entry-content\">\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n c\u00e1c front ch\u1eef kh\u00e1c nhau trong excel s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Heounique l\u1ecdc kh\u00f4ng tr\u00f9ng<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-hien-thong-bao-trong-excel-su-dung-add-ins-hocexcel-online.html\">H\u00e0m hi\u1ec7n th\u1ecb th\u00f4ng b\u00e1o trong Excel s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-ten-va-dia-chi-doanh-nghiep-trong-excel-su-dung-add-ins-hocexcelonline.html\">T\u00ecm ki\u1ebfm t\u00ean c\u00f4ng ty v\u00e0 \u0111\u1ecba ch\u1ec9 c\u00f4ng ty d\u1ef1a v\u00e0o m\u00e3 s\u1ed1 thu\u1ebf<\/a>\n<\/p>\n<\/div>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-307.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3874,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3873","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3873","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3873"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3873\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3874"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3873"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3873"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3873"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}