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

JOINs in MS SQL Server

Medical Center database
Non primary-foreign key JOINs
Non-equi JOINs
Non-equi self JOINs
Summary

Instruction

Great! Let's look at two more tables. This time we'll work with Apartments and Couples.

Exercise

Select all data from the Apartments table.

It has the following columns:

  • Id – the ID of a given apartment,
  • Location – the name of the city where a given apartment is located,
  • Price – the price of a given apartment, and
  • Rating – the rating of a given apartment.

Stuck? Here's a hint!

Type: 

SELECT
  *
FROM Apartments