Hi
I have a problem. I trying to create a database for buying pattern analysis. I have a set of table: customer and item. I want to create a query which will display, all the item that were bought by this customer who bought item ID p23541.
Which mean I need to set item ID p23541 as my main that lead to a specific customer and I want to know what else did he bought. So I imagine that I need to query? but can it be done
Thank you