Keywords: database , join , sql

Here is an example of when you might want to use each type:

https://theprogrammersfirst.wordpress.com/2020/07/22/what-is-the-difference-between-left-right-outer-and-inner-joins