1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to SQL Server

Exercise

Join the UNION

You can write 2 or more SELECT statements and combine the results using UNION. For example, you may have two different tables with similar column types. If you wanted to combine these into one set of results, you'd use UNION. You'll see how to do this using the artist and album tables. In this exercise, you'll SELECT two common columns, add a description, then a Source column so you can tell which table the columns originated from.

Instructions

100 XP

Make the first selection from the album table. Then join the results by providing the relevant keyword and selecting from the artist table.