🔗 Intro to joins
What is a join?
Joining refers to combining rows from two or more database tables. Imagine a simple database with just 2 tables: A Customers table An...
Types of join
In this post, the left table (or table A), means the table you're starting from. The right table (or table B), means the table you're...
Database table relationships
Three types of relationship exist between related tables. 1️⃣ One-to-One One record in a table is associated with one record, and only o...