Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement