musicales - 5:01 pm on Mar 30, 2009 (gmt 0)
Thanks. The trouble I'm having is that I can't pull out one product id. To do so I would have to use the query in question - in other words, I have to find all the sessions that have looked at product a, then select all the other products that those sessions have looked at. That in itself makes for a very hefty query that in most cases times out. Is there a standard way of going about building a 'customers who bought this also bought this' database that will scale beyond a few thousand products/records.