I'd probably do something silly like this:

declare @somedata table (ID int primary key identity (1,1)

,field1 int

)

insert into @somedata (field1) values (83944)

insert into @somedata (field1) values (83955)

insert into @somedata (field1) values (83954)

insert into @somedata (field1) values (83951)

insert into @somedata (field1) values (83947)

insert into @somedata (field1) values (83946)

insert into @somedata (field1) values (83953)

select tbl.field1

, tbl.field2

, tbl.field3

FROM table tbl inner join

@somedata sd on tbl.field1 = sd.field1

order by sd.ID

Kurt