I recently saw join syntax that I had never seen before in my 50-year career: NATURAL INNER JOIN. As I was curious about what that even meant, I decided to investigate, and it is extremely clever. Many databases now have the NATURAL INNER JOIN or NATURAL OUTER JOIN capability, which you will see below.

It is such a revolutionary advancement that I assembled a five-minute video to explain it across multiple databases. Like me, I bet this will be the first time you have heard about it, and like me; you will see the possibilities have incredible potential.

Posted in Blog