求助排序问题-有难度

[dxb321]

设我有一字段,其只包含数字{0,1,2,3},我想查询结果按这样方式排序 1,2,3,0.怎样写查询语句.
例:
name flag
a 0
a 1
c 2
b 3
查询结果为:
name flag
a 1
c 2
b 3
a 0

[trampwind]

select * from tabname where flag<>0 order by flag union all select * from tabname where flag=0;

[dxb321]

up

[mathematician]

用union 就可以了，我用mysql调试通过，你根据access语法自己修改一下吧！
select name,flag from tab_name where flag<>0 order by flag
union all
select name,flag from tab_name where flag=0;

[mathematician]

刚才那句有点问题，改正如下：
select name,flag from tab_name where flag<>0
union all
select name,flag from tab_name where flag=0;

[yesyesyes]

select * from tbl order by case when flag=0 then flag*100 else flag end