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
4. Get to know the Treatment table
Non primary-foreign key JOINs
Non-equi JOINs
Non-equi self JOINs
Summary

Instruction

Great! Here comes the last table for now. Let's get to know some treatment types.

Exercise

Select all data from the Treatment table. As you can see, it has only four columns:

  • Id – the ID of a given treatment,
  • Name – the name of a given treatment,
  • Price – the price of a given treatment, and
  • Type – the type of a given treatment.

Stuck? Here's a hint!

Type: 

SELECT
  *
FROM Treatment