18.2 Joins: LEFT, RIGHT, INNER, OUTER

So far, your SQL has been fairly simple. But the real power of SQL is realized when you begin joining two or more tables together to get new combinations of data. Follow along with the videos below to learn how to join.

  1. Write a SQL statement that will show all employees who work in Georgia. Show Last Name, First Name, and Location City fields.

    • "implied" inner join: table.primarykey = table.foreignkey

  2. Write a SQL statement that shows all the managers and the city where they are a manager. Display Location City, First Name, Last Name, Position Title. Order by Location City.

    • multiple inner joins

  3. Write a SQL statement that...

    • INNER JOIN ON

  4. Write a SQL statement that...

    • LEFT JOIN ON

  5. Write a SQL statement that...

    • RIGHT JOIN ON

  6. Write a SQL statement that...

    • OUTER JOIN ON
Previous Next