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.

Challenge: Multi-condition joins

Challenge: Multi-condition joins - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Challenge: Multi-condition joins

“

- [Instructpr] Okay, time for your assignment on multi-condition joins. Your business partner, Uncle Jimmy, just let you know that the manager from Store 2 is working on expanding your film collection. He wants you to pull a list of the distinct titles and their descriptions, which are currently available in inventory at Store 2. Here's a preview of the results. You're going to want title and description. Because this is the multi-join assignment, I want you to do this using a multi-condition join so you're not allowed to use a WHERE clause. Per usual, try to do this on your own, struggle through it, and then come back and watch the solution video. Good luck.

Contents