Blog : Bundle of items in market basket analysis

Bundle of items in market basket analysis 

Hi all,

tid	name	description
1	one	ones
1	four	fours
1	three	threes
1	eleven	elevens
1	six	sixes
2	ten	tens
2	eleven	elevens
2	five	fives
2	four	fours
2	seven	sevens
3	one	ones
3	eleven	elevens
3	twelve	twelves
3	six	sixes

the above is my actual table

After doing market basket analysis i got ,like

Bundle of items	Bundle size	Number of sales
one, eleven	2	2
six, eleven	2	2
four, eleven	2	2
six, one	2	2
six, one, eleven	3	2

from this i need description  for bundle of items like u can observe i need one,eleven  for that i need description column like ones,elevens 

 please help

Answers 

Select T1.tId, T1.proddesc As Product1, T2.proddesc As Product2,

  T3.proddesc As Product3

  From ProductAssociation_prodesc As T1

  Join ProductAssociation_prodesc  As T2

  On T2.tId = T1.tId

  And T2.Proddesc > T1.Proddesc

  Join ProductAssociation_prodesc  As T3

  On T3.tId = T1.tId

  And T3.Proddesc > T1.Proddesc