>>>Select A1.*, B1.* from cur A1 INNER JOIN cur B1 on A1.ID < B1.ID
>>>
>>>This should create all possible combinations.
>>
>>Naomi,
>>
>>This is a little bit to fast for me.
>>
>>We have one table only and you are selecting from tables, table A1 and table B1 , would you be able to elaborate ?
>>Would this work also if you have a set of n records?
>>
>>Regards,
>>
>>Koen
>
>I'm selecting from the same table but I join it with itself. It should work for any number of records, it will create all combinations.

Naomi,

I am afraid you will not get the permutations as requested with this select statement. I see only 2 figures that is not according to the question as far as I can see.

Regards,
Koen