How to query more than one table
1. Data from multiple tables
Creating JOINs
Referencing columns
Let's practice

Instruction

Hey there! Since you've completed Part 2 of our T-SQL course, you already know how to get data from a single table. You've also learned how to filter rows to only get those that you really need. Superb!

Single tables might seem handy at first, but in big databases, we always use multiple tables. This also means that we often want to get data from more than one table at a time. By the end of this part, you'll know how to join results from multiple tables.

Exercise

Click Next exercise to proceed.