records). The final query should give you the first 7 of this SELECT. If
you have several providers with the same date, they may not come in the
same order in the inner select as in the sorted table.
> -----Original Message-----
> From: Lofback, Chris [mailto:[EMAIL PROTECTED]
> Sent: donderdag 27 mei 2004 15:51
> To: CF-Talk
> Subject: RE: PL/SQL stumper
>
> It looks like this is as close as I can get but it still
> doesn't work quite right. When I dump the records used by
> this query and sort them in date order, I have a value that
> is second in the list that does not make the final top 7...
> I don't understand why but I'll keep chopping at it.
>
> Thanks all,
> Chris
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]