Why do I have a cartesian duplicate here?
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
I assume there is more than one order detail/order per Employee? Can you do SELECT * and see what you get there? Plus, might be easier for others if the query from the question is a text rather than a picture.
sorry, next time. thank you
16 People are following this question.
Remove possible duplicates
Removing duplicates from data
Duplicate pivot colunns
Sql Server Find & remove duplicate indexes
"Duplicate" results as Subtotal using WITH Rollup