Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

SQL Basics in MS SQL Server

How to query more than one table
Creating JOINs
5. The JOIN keyword
Referencing columns
Let's practice

Instruction

Excellent! Now the result looks much better, right?

Joining two tables is such a popular and frequent operation that SQL provides a special keyword for it: JOIN. There are many types of JOINs out there. For the time being, we'll focus on the basic one.

Exercise

Click Next exercise to proceed.