Show customers and their sales reps SELECT c.customerName, e.firstName AS salesRepFirstName FROM customers c INNER JOIN employees e ON c.salesRepEmployeeNumber = e.employeeNumber; -- 5.
When an Active Record method is called, the query is not immediately generated and sent to the database. Instead, the query is sent only when the data is actually needed. So each example below ...