From the course: Database Foundations: Intro to Databases

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Combine data with JOIN

Combine data with JOIN

From the course: Database Foundations: Intro to Databases

Start my 1-month free trial Buy for my team

Combine data with JOIN

“

- [Instructor] In a relational database, information is split up across multiple related tables. This provides an efficient way to store the data, but it makes retrieving information a little bit more difficult. Luckily, queries help us piece everything back together again. I'm going to start a new query in the two trees database by pressing control N on my keyboard. That'll pop open a new tab and attach it to the database that I have currently selected over here in the connections pane. Now I want to review information about a single product. I'll say select star from products dot products where the S-K-U or where the SKU is equal to ALB008. This shows me that that product corresponds to the eight ounce size delicate oil in category number one. But what does category number one mean? We stored that information in a separate table. We can query that table to find out. Let's write another query here. This time, we'll select…

Contents