Connect Tables - JOIN - Intro

By this point, you already know how to perform the main CRUD operations with SQLModel using a single table. 🎉

But the main advantage and feature of SQL databases is being able to handle related data, to connect or "join" different tables together. Connecting rows in one table to rows in another.

Let's see how to use SQLModel to manage connected data in the next chapters. 🤝

Tip

We will extend this further in the next group of chapters making it even more convenient to work with in Python code, using relationship attributes.

But you should start in this group of chapters first. 🤓