Not sure how to Query 2

[bdichiara]

I have a table that needs to be separated first by `type`, then by `state`, then sorted by `name`

The problem I want `type` to be in a specific order. Right now, there are 3 types:
free, surcharge, and fee

I want them to show up in that order, but i can't do it Alphabetically ASC or DESC.

Inside those 3 groups, I want it to group all similar states together. (this can be alphabetical)

Last, I want each group to be alphabetical (ASC) by `name`.

How would I go about accomplishing this?

_______________
_brian.

 

[r937]

order 
    by case when type='free' then 1
            when type='surcharge' then 2
            when type='fee' then 3
                 else 4 end
     , state
     , name

r937.com | rudy.ca

 

[bdichiara]

excellent! Works perfectly!

_______________
_brian.