From the course: MySQL Data Analysis

Unlock this course with a free trial

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

Solution: Bridging tables

Solution: Bridging tables - MySQL Tutorial

From the course: MySQL Data Analysis

Solution: Bridging tables

- [Instructor] This is the solution video for the bridging assignment. As a reminder, we're trying to pull the actor's first name, the actor's last name, and the titles that the actor appeared in. We're going to need to employ a bridge. Let's jump into workbench and walk through the answer. All right, so here you see I've actually started to stub out the solution without even talking about the tables that we're going to use yet. So sometimes I use this method, I use the alias for the columns that we're looking for. This can kind of just help frame the problem you're trying to solve, and then you go ahead and fill it in from here. So we know we need the actor first name and last name. We can start to take a look at the tables here. Probably has something to do with actor. We can start there. We look in the columns and we see first name, last name. It looks like that'll be a good place to start. So let's call these in here. We'll say from actor. And we'll say actor.first_name, and we'll…

Contents