Posted by John Bell on 01/21/06 02:31

Hi

Sorry for the delayed reply, this one slipped through the net.

My question was related to

There is a problem with that..
For example:
Table1:
OrderID
1
2
3
4
5
6
7
8
Table2:
OrderID UserID
6 1001
7 1001
3 1002
4 1002
the result will be:
for user 1001
8
5
4
3

Do you actually want 3,4,5 as this is less than the maximum for 1001 which
is already 7?

John
<stockblaster@gmail.com> wrote in message
news:1137449155.173528.136550@g14g2000cwa.googlegroups.com...
> Hello John.
>
> I am not sure i understand, do you mean if table1 contains only two
> records? so the top 4 will not work?
>

[Back to original message]