declare @Table1 table (number int, number1 int)
declare @Table2 table (number int, Outputfile varchar(100))
declare @Table3 table (number int, SequenceNo int)

insert into @Table1
select 1,4500
union select 2,4501
union select 3,4503
union select 4,4504
union select 5,5501
union select 6,5502
union select 7,5504

insert into @Table2
select 1, 'First Output'
union select 2, 'First Output'
union select 3, 'First Output'
union select 4, 'First Output'
union select 5, 'Second Output'
union select 6, 'Second Output'
union select 7, 'Second Output'

insert into @Table3
select 1, 1
union select 2,2
union select 3,5
union select 4,4
union select 5,3
union select 6,2
union select 7,1

select t1.number, t2.Outputfile, t3.SequenceNo 
from @Table2 t2 
inner join @Table3 t3 
	on t3.number = t2.number
inner join @Table1 t1 
	on t1.number = t3.number
order by t2.Outputfile, t1.number1

quote:

---

Originally posted by RickD

.....I need to find out if the values are in the correct sequence.

---

3	First Output	5
4	First Output	4
5	Second Output	3
6	Second Output	2
7	Second Output	1