Question

Retrieve customer records for sales representative Barry Jones and identify if the relationships are one-to-one or one-to-many. Remember: Select, from, inner join, and where. Use Barry's employeeNumber, 1504, and perform a join between the customer salesRepEmployeeNumber to retrieve these records.

Answer 1

SELECT c.customerName, c.customerNumber, e.employeeNumber
FROM customers c
INNER JOIN employees e ON c.salesRepEmployeeNumber = e.employeeNumber
WHERE e.employeeNumber = 1504;