There are two tables with two columns: Product and Frequency of purchase; the Customer and Frequency of Purchases. When you choose the product number one shows the clients who bought them. You want to find the product number two at those customers who bought a product number one. Further, when we receive customers who purchased product number two, you need to know the third most important product from these customers.
In the end it should be a table with 6 columns: the main product - the frequency of purchases; supporting product - frequency of purchase; product support - frequency of purchase.
I'm sorry to say, but you have no connection between the two tables, ence you can't do what you want. Provide us some form of connecting the data. What you have is two dimension tables, one for Products and the other for Customers, you really need a fact table like an Order table wich will contain the information of the client and what product or products the client bought. If you have thar table and provide us, then we can make you a solution for your problem.
