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: The UNION operator

Solution: The UNION operator - MySQL Tutorial

From the course: MySQL Data Analysis

Start my 1-month free trial Buy for my team

Solution: The UNION operator

“

- [Instructor] This is the solution video for your assignment on union. As a reminder, you're trying to pull a list of all of your advisors and staff and denote the type of person that they are, advisor or staff, and pull in their first name and last name. Let's go over to Workbench and walk through the solution. So by now you should be pretty familiar with our first step, which is to figure out which tables we're working with. So we know that we want to pull in the names of our advisors and our staff. So we're going to start looking at those tables. Here we've got advisor. We're going to hope that we have, yep, first name and last name in these columns. So we're going to pull from there first. First name, last name, from advisor, and we'll just see what that looks like. So we've got the names of the advisors and then similarly we're going to take a look at our staff table as well and see if that has first name and last name. Turns out it does right here. So we're going to want to put…

Contents