<----LEFT JOIN ----------------------- RIGHT JOIN-----> VARIATIONS

I simply used HR tables DEPARTMENTS AND EMPLOYEES

What does left join do?

Simple.

It takes all datas from the left table  even not matching with the datas joined table's joined datas..

What is from the left table? The table at the left side when joining operation is operated.

LEFT JOIN

RIGHT JOIN

ANOTHER VARIATIONS

LEFT JOIN

RIGHT JOIN

LEFT JOIN

RIGHT JOIN