- MySQL 8 for Big Data
- Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel
- 74字
- 2021-08-20 10:06:14
RIGHT JOIN
RIGHT JOIN fetches all records from the right and common records from the left table. If we use the customer and order table example with right join, it will fetch all records from the customer table even if there are no matches in the left table (order). To fetch all customer details with order, the following query can be used:
SELECT order.order_id, customer.name
FROM order
RIGHT JOIN customer ON order.customer_id = customer.customer_id;
推薦閱讀
- 青少年軟件編程基礎與實戰(圖形化編程三級)
- MySQL 8 DBA基礎教程
- 名師講壇:Java微服務架構實戰(SpringBoot+SpringCloud+Docker+RabbitMQ)
- PHP+MySQL+Dreamweaver動態網站開發實例教程
- 精通Python自然語言處理
- 從Excel到Python:用Python輕松處理Excel數據(第2版)
- Apache Kafka Quick Start Guide
- Learning OpenStack Networking(Neutron)
- Python Data Analysis Cookbook
- Spring Boot+Vue全棧開發實戰
- 時空數據建模及其應用
- Python 3.7從入門到精通(視頻教學版)
- Cocos2d-x Game Development Blueprints
- Qlik Sense? Cookbook
- 官方 Scratch 3.0 編程趣味卡:讓孩子們愛上編程(全彩)