- 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:

推薦閱讀
- Oracle WebLogic Server 12c:First Look
- JavaScript從入門到精通(微視頻精編版)
- Oracle Exadata性能優化
- Visual Basic編程:從基礎到實踐(第2版)
- Developing Mobile Web ArcGIS Applications
- Python從菜鳥到高手(第2版)
- Data Analysis with IBM SPSS Statistics
- SEO實戰密碼
- Reactive Programming With Java 9
- Windows Forensics Cookbook
- Java編程技術與項目實戰(第2版)
- Mastering Gephi Network Visualization
- UML軟件建模
- Learning Apache Thrift
- jBPM6 Developer Guide