https://betapython.com/difference-between-inner-left-right-and-full-join/
Join | What's The Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN And FULL JOIN?