>>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.
If it's not broken, fix it until it is.
My Blog