re: How to write this SQL select the best way? VIEW POST

FULL DISCUSSION
 

I won't weigh in with a solution as Dian Fey already did.. but a couple of thoughts.

If you have a hard time explaining the result, try giving a few examples of the desired result.

Also, may be out of your control but that text field for itemid just about breaks my heart.

Good luck getting your data out! :)

 

Yeah Kevin I feel the same about the column for the item but I can't change it unfortunately, it's part of a big erp system 😅 if I could, I definitely would change it 😁

 
code of conduct - report abuse