The advantage of using a relational database management system is that the data can be easily joined together from different tables and can be returned to the user in a single bulk. This greatly improves the productivity of the developers as it allows fluidity and flexibility when it comes to designing a complex database structure.
There are many types of JOIN statements in MariaDB/MySQL—INNER JOIN, FULL OUTER JOIN, LEFT JOIN, and RIGHT JOIN. All of these different JOIN statements behave differently when executed, which you can see in the following image:
Most of the time, we'll be using the INNER JOIN statement, as it only returns the ...
