DEV Community

Discussion on: How to write this SQL select the best way?

Collapse
 
torpne profile image
Kevin McKenna

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! :)

Collapse
 
darksmile92 profile image
Robin Kretzschmar

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 😁

Collapse
 
torpne profile image
Kevin McKenna

Been there, done that!