select FirstName, LastName,saleAmount,saleDate from Sale left outer join SalesRep on Sale.SalesRepId = SalesRep.SalesRep

First of all task 5 of challenge https://teamtreehouse.com/library/querying-relational-databases/joining-table-data-with-sql/join-queries is

Show all SaleDate, SaleAmount, and SalesRep First and Last name from Sale and SalesRep. Make sure that all Sales appear in results even if there is no SalesRep associated to the sale.

But not what you wrote (it is task 3):

Show the First and Last Name of each sales rep along with SaleAmount from both the SalesRep and Sale tables in one result set.

In order to solve your query you have to follow the order specified in the task:

• SaleDate
• SaleAmount
• FirstName
• LastName

In your case as you see order is wrong, so the query should look like this:

SELECT Sale.saleDate, Sale.saleAmount, SalesRep.firstName, SalesRep.lastName
FROM Sale LEFT OUTER JOIN SalesRep 
ON Sale.salesRepId = SalesRep.salesRepId

I also added id at the very end of query SalesRep.SalesRepId.

Make sure you check markdown cheatsheet when post question. It is right below the window where you type question.

And always provide link to challenge.

The easier to reproduce the error you have the faster and easier will it be to help you.

I'm not receiving a correct response with what you provided.

This one took a while BUT I think the order of the answer threw some folks off. Here's what I got after re-reading the question.

SELECT SalesRep.firstName, SalesRep.lastName, Sale.saleAmount FROM Sale INNER JOIN SalesRep ON Sale.salesRepId = SalesRep.salesRepID;

cheers,