OT: Special sorting
Hi!
I have a customer who wants a special sort of data.
They have categories of products like so.
By default its sorted like this
Animals, accessories, misc, mindblowing
What they want is, always have accessories and misc at the end like, Animals, Mindblowing, Accessories, Misc
Accessories and Misc always have a groupcode of 98 and 99
Is it possible or should a use a second query and then union the result?
Martin Arvidsson, Data Martin i Kungsbacka AB
I have six locks on my door all in a row. When I go out, I lock every other one. I figure no matter how long somebody stands there picking the locks, they are always locking three.