- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 122字
- 2021-08-20 10:06:13
SQL JOINS
Join is used to retrieve data from multiple tables. For example, if there are two tables, order and customer, and we want to retrieve data, it is possible using the JOIN clause.
The different types of JOIN are as follows:
- INNER JOIN: Returns only those records which have matching values in both tables.
- CROSS JOIN: Returns only those records which are have matching values in either the left or right table.
- LEFT JOIN: This will returns all records from the left table and only matching records from the right table.
- RIGHT JOIN: This will returns all records from the right table and only matching records from the left table.
The following figure illustrates the example that we looked at briefly:
推薦閱讀
- Learning Apex Programming
- MATLAB實用教程
- 你必須知道的204個Visual C++開發問題
- Visual C++數字圖像處理技術詳解
- MySQL數據庫基礎實例教程（微課版）
- Building an RPG with Unity 2018
- Learning JavaScript Data Structures and Algorithms
- 數據結構習題解析與實驗指導
- Microsoft Dynamics AX 2012 R3 Financial Management
- Java Fundamentals
- Learning Ionic
- Moodle 3 Administration（Third Edition）
- HTML5移動前端開發基礎與實戰（微課版）
- 會當凌絕頂：Java開發修行實錄
- 啊哈C語言！：邏輯的挑戰（修訂版）