CommencerCommencer gratuitement

Inner joins

Let's start combining data from multiple tables! The sales support department received a call from a customer asking to speak to the employee that helped her with her purchase. You decide to get them the necessary information. You know that the customer's name is Mark Philips.

To get the name of the employee, you will need to use data from both the Customer and the Employee tables. Let's make sure this customer gets in touch with the right employee.

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select the customer's and employee's first and last names
SELECT c.FirstName, ___, ___, e.LastName
-- Join the Customer and the Employee tables
FROM Customer c ___ ___ Employee ___
	-- Complete the common joining column
	___ c.SupportRepId = ___
Modifier et exécuter le code