Databases Querying Relational Databases Joining Table Data with SQL JOIN Queries

maria mozglyakova
maria mozglyakova
810 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;

1 Answer

Steven Parker
Steven Parker
182,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
Steven Parker
Steven Parker
182,341 Points

maria mozglyakova — Glad to help. You can mark a question solved by choosing a "best answer".
And happy holidays!   :christmas_tree: