• If you were to use inner join and the Mary sales record had 2 entries, each entry would join to the POSS table causing duplication.  I don't think inner join is the way to go.