Quick DMX Question

Is there anyway to predict what a customer is likely to buy based on their purchase history?



What I would like to do is something simliar to using a natural prediction join with multiple union selects, but with data supplied from my purchases table.



So I need something like this:




Code SnippetOpenquery([ds], 'SELECT DISTINCT [PurchasedProductID] FROM [Table] WHERE [CompanyName] = 'a')



To work like how this works:




Code Snippet(SELECT (SELECT '1234' AS [ProductID] UNION SELECT '12345' AS [ProductID]) AS [Table])





Thanks!