Hi Folks,

On a typical e-commerce application, any ideas on how to create the SQL for a 'People who bought this product, also bought...' ? Assuming here that all past order lines are stored in a table which includes order_id, customer_id, product_id etc. Basically, can it be done in one query (I'm using MySQL so no stored procedures) or do I need to look towards nested queries? Any pointers, suggestions or recoomienations would be great.

Thanks,

Simon