🔗 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...