How to use INNER, LEFT and RIGHT joins to find data present or absent in a database

Though i would do something different today, here is an illustration of the effect of INNER, LEFT and RIGHT joins and how to use them to find actual and missing data.

6 Likes