1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to BigQuery
Connected

Exercise

RIGHT, LEFT, and OUTER joins

While the INNER JOIN is one of the most used joins, other times, you will also need to join data that includes results not matching the join condition from one or both of the tables in the join. This exercise will walk through the various join types in BigQuery and how you use them.

Instructions 1/3

undefined XP
  • 1
    • Complete the join to include all values (matching and not) from the orders CTE.
  • 2
    • Complete the join to include all values (matching and not) from the products CTE.
  • 3
    • Complete the join to include all values (matching or not) from the orders and products CTE.