# SQL Notes: Exercise 3 - SELECT Using Inner Joins

Name: _____________________________________

Write a SELECT statement which produces the results. Put each clause (FROM, WHERE, ...) on a separate line. Unless otherwise specified, use the example database from the book SQL: The Complete Reference.

1. List the (busy) salesreps who have taken orders for other (lazy) salesreps. These are the orders where the rep that took the order is not the same as the customer's rep. Give their names and the amount of each order. Note that this uses a table which doesn't appear in the SELECT output, but is necessary to cause the correct records (rows) to appear.