1 inner join

image.png

2 left join

image.png

3 right join

image.png

4 full join

image.png