for sql 2000..
There is No row_number()
I have to make memory table. something like this
declare @t table(autoID int IDENTITY(1,1), seq int)
insert into @t (seq) SELECT a.seq from tablea as a, tableb as b where a.char_type = b.type order by a.ppoint desc
select t.autoID, a.* FROM @t as t, tablea as a where t.seq = a.seq order by t.autoID