Mufasa,
You are right, it works, It is just that the execution time for the query (which is a little more complicated than I showed) jumps from 3-4 seconds to 25-30 when I add in that extra select statement.
Sem,
Yeah, I pointed out the ordering problem also. Specifically the values 'N'...