Input
sports:
league player sport ------ --------- --------------- mens Albert baseball womens Angela tennis mens Albert basketball womens Angela golf mens Albert golf womens Angela baseball mens James soccer womens Barbara basketball mens James track and field womens Barbara baseball mens James tennis womens Barbara lacrosse mens Jerry rugby womens Christine basketball mens Louis baseball womens Christine baseball mens Louis basketball womens Christine soccer mens Martin soccer womens Dianne rugby mens William tennis womens Dianne lacrosse mens William golf womens Madeleine track and field womens Margrethe golf womens Margrethe lacrosse womens Nancy track and field womens Nancy soccer womens Nancy tennis womens Ruth soccer womens Ruth track and field
SQL Call
CREATE MULTISET TABLE sports_combinations_bg AS ( SELECT * FROM BasketGenerator ( ON sports PARTITION BY player USING TargetColumns('sport') Basketsize(2) Accumulate('player') OutputCombinations('true') ) AS dt ) WITH DATA;
Output
SELECT * FROM sports_combinations_bg;
player sport1 sport2 --------- ---------- --------------- Barbara basketball lacrosse Louis baseball basketball William golf tennis Nancy soccer track and field Barbara baseball lacrosse Margrethe golf lacrosse Nancy soccer tennis Barbara baseball basketball Angela baseball tennis Nancy tennis track and field Angela golf tennis Dianne lacrosse rugby Angela baseball golf Albert basketball golf Christine baseball soccer Albert baseball golf Christine basketball soccer Albert baseball basketball Christine baseball basketball Ruth soccer track and field James tennis track and field James soccer track and field James soccer tennis