一条有相当难度的SQL语句

[fjxmt]

有二表:
表grade
user grade
a 1
b 2
c 3
d 4
e 5
f 6
g 7
h 8
i 3
j 4
k 8
l 2

表content
user content
a sdfas
a sfsd
b sdfsd
c 544455
i fsdfey
e sfsdfa
i fsdfs
a sekkeke


要求:
查询表content，排序是这样，凡表grade中的grade值为3、5、8靠前显示，其它值靠后，

请教各位方家，不胜感激。

[一把编程的菜刀]

。。。。。

20分真值……

[zl_c]

select *,g=(select case when grade in (3,5,8) then 0 else 1 end from grade where [user]=a.[user]) from content a order by g

[fjxmt]

[Quote=引用 2 楼 zl_c 的回复:]
SQL codeselect *,g=(select case when grade in (3,5,8) then 0 else 1 end from grade where [user]=a.[user]) from content a order by g
[/Quote]

改：

SQL codeselect *,(select case when grade in (3,5,8) then 0 else 1 end from grade where [user]=a.[user]) as g from content a order by g