Perform successive left joins to fetch information about the constituent elements of the combinations
Useful links