Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to? Get every possible combination.....
Message
 
To
28/06/2002 14:08:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00673417
Message ID:
00673487
Views:
16
>I have one table from wich I want to combinate every possible combination between records. I am trying to do that for all the last week. Some idea? Thanks.

Depending on the way you organize the records, VFP can do that directly for you.

Suppose that I have a table "table_a" with a field named "value_a" and another table "table_b" with a field named "value_b". To obtain any possible combinations of the values of the 2 fields all I have to do is doing a select without "where" clause between both tables. If there is 10 diffenrent values in value_a and 100 values in value_b the result will be a table with 10*100 records. Be careful with this kind of select, the result can be really big if many records are selected!
SELECT value_a, value_b FROM table_a, table_b INTO CURSOR CombinedValues GROUP BY 1,2
HTH :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform