SQL语句RIGHT JOIN

SQL RIGHT JOIN 关键字

RIGHT JOIN关键字会从右表(TABLE_NAME2)那里返回所有行，即使在左表(TABLE_NAME1)中没有匹配行。
RIGHT JOIN 关键字语法

SELECT COLUMN_NAME(S) FROM TABLE_NAME1 RIGHT JOIN TBALE_NAME2 ON TABLE_NAME1.COLUMN_NAME=TABLE_NAME2.COLUMN_NAME

注释:在某些数据库中，RIGHT JOIN称为RIGHT OUTER JOIN。

DUCK表:

DUCK_ID NAME YEAR HK234 DUCK01 2016 DK244 DUCK02 2016 KK134 DUCK03 2016

MEAT表:

MEAT_ID KIND PRODUCTION_YEAR DUCK_ID LO23 DUCK 2016 KK134 LO93 DUCK 2016 DK244 LO03 DUCK 2016 HK234 LO66 DUCK 2016 CO134

---

右连接(RIGHT JOIN)实例
列出所有数据

SELECT M.MEAT_ID,D.DUCK_ID,M.KIND,M.PRODUCTION_YEAR,D.YEAR FROM MEAT M RIGHT JOIN DUCK D ON M.DUCK_ID=D.DUCK_ID ORDER BY M.MEAT_ID;

结果:

MEAT_ID DUCK_ID KIND PRODUCTION_YEAR YEAR LO03 HK234 DUCK 2016 2015 LO23 KK134 DUCK 2016 2016 LO93 DK244 DUCK 2016 2016

RIGHT JOIN关键字会从右表(DUCK)那里返回所有行

---