maria mozglyakova810 Points
hi. Why it is not right join (i must to save all records from Sale). Why i am wrong?
select saledate, saleamount, firstname, lastname from salesrep right outer join sale on salesrep.salesrepid = sale.salesrepid;
Steven Parker182,341 Points
You didn't say which task you were working on, but assuming it's task 3, I see two issues:
- the instructions did not ask for "SaleDate"
- the logic requires an inner join