From the course: SQL Essential Training

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Joining many tables

Joining many tables - SQL Tutorial

From the course: SQL Essential Training

Start my 1-month free trial Buy for my team

Joining many tables

“

- [Instructor] Now that we have identified the fields that we need to respond to the current request from WSDA Music Management, which is what employees are responsible for the 10 highest individual sales. Let's go ahead now and start building out our SQL query that's going to respond to this request. Now, starting with the FROM clause, we can identify the first table that we need which is the Invoice table. We want to alias this Invoice table as i. Next, we want to now join this table to the first table that we need to respond to this inquiry which is the Customer table. So we're now going to put our keyword INNER JOIN and then we specify the Customer table because that's the table we're going to join to. We want to alias this table as c for customer. And now, we are ready for ON keyword, which is going to tell us the exact fields that we're going to be joining the Invoice to the Customer tables. Now, we're going to say…

Contents