asp去掉有负数的重复数据

<SCRIPT type=text/javascript><!--google_ad_client = "pub-1184677496929096";google_ad_width = 468;google_ad_height = 15;google_ad_format = "468x15_0ads_al_s";google_ad_channel = "";google_color_border = "000000";google_color_bg = "FFFFFF";google_color_link = "000000";google_color_text = "000000";google_color_url = "008000";//--></SCRIPT><SCRIPT src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript></SCRIPT>

<SCRIPT type=text/javascript><!--google_ad_client = "pub-1184677496929096";google_ad_width = 336;google_ad_height = 280;google_ad_format = "336x280_as";google_ad_type = "text";google_ad_channel = "";google_color_border = "FFFFFF";google_color_bg = "FFFFFF";google_color_link = "000000";google_color_text = "000000";google_color_url = "008000";//--></SCRIPT><SCRIPT src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript></SCRIPT>

表字段 id username point
1 a 1
2 b 5
3 c 8
4 a 10
5 b 5
6 a -1
7 b 20
要显示结果
b 30
c 8
去掉有负数的用户a
我用户的错误语句是
rs0.open "select username, sum(point)as point from tab where username not in(select point<0 group by username) and point>0 group by username",conn,1,1

 

==========================================================

select username, sum(point) as point
from tab
where username not in (select username from tab where point<0 )
and point > 0
group by username