SQL RIGHT JOIN or RIGHT OUTER JOIN

It returns all rows from right table and matched rows from left table. If no matching rows from left table, then it will return NULL values

For example EMPLOYEE Table has

EMP_IDEMP_NAMEHIRE_DATESALARYDEPT_ID
1Roger Fed2001-05-0150004
2Djoker Nova2002-07-1565001
3Stef Graph2005-10-1880005
4Mart Hingis2007-01-0372003
5Andre Duplesi2008-06-245600null

DEPARTMENT Table has

DEPT_IDDEPT_NAME
1French Open
2Wimbledon
3US Open
4Aus Open
5Olympics Games

Now lets write RIGHT JOIN query:

SELECT D.DEPT_ID, D.DEPT_NAME, E.EMP_NAME, E.SALARY  

FROM  EMPLOYEE E, DEPARTMENT D

RIGHT JOIN DEPARTMENTS

ON E.DEPT_ID =D.DEPT_ID; 

The Output will be like this:

DEPT_IDDEPT_NAMEEMP_NAMESALARY
1French OpenRoger Fed5000
1French OpenDjoker Nova6500
3US OpenMart Hingis7200
4Aus OpenRoger Fed5000
4Aus OpenRoger Fed5000
4Aus OpenRoger Fed5000
4Aus OpenRoger Fed5000
4Aus OpenRoger Fed5000
5Olympics GamesStef Graph8000

Learn more : SQL Tutorial , SQL Interview Questions