Left Join 关键字会在左表 (EMP) 那里返回所有的行,即使在右表 (SAL) 中没有匹配的行,例如:
select * from EMP Left join SAL on EMP.ENAME = SAL.ENAME;
RIGHT JOIN 关键字会在右表 (SAL) 那里返回所有的行,即使在左表 (EMP) 中没有匹配的行,例如:
Select * from EMP Right join SAL on EMP.ENAME = SAL.ENAME;
Inner Join关键字显示的是两个表相关的信息,例如:
SELECT * FROM EMP inner join SAL on EMP.ENAME = SAL.ENAME;
Full Join关键字显示的是两个表全部的信息,例如:
SELECT * FROM EMP full join SAL on EMP.ENAME = SAL.ENAME;