query help - people who have bought this item have also bought

Hi I'm looking to create a query that will look through my previous orders and create a table of what items have sold with what products. My current table that holds the order details is set up like this. orderID, productID, quantity. Any suggestions would be appreceiated. Thanks, Chuck --

Re: query help - people who have bought this item have also bought

At 11:02 -0500 7/24/03, Chuck Barnett wrote: Hi I'm looking to create a query that will look through my previous orders and create a table of what items have sold with what products. My current table that holds the order details is set up like this. orderID, productID, quantity. I see an order ID

RE: query help - people who have bought this item have also bought

[snip] Hi I'm looking to create a query that will look through my previous orders and create a table of what items have sold with what products. My current table that holds the order details is set up like this. orderID, productID, quantity. Any suggestions would be appreceiated. [/snip] You

Re: query help - people who have bought this item have also bought

* Chuck Barnett Hi I'm looking to create a query that will look through my previous orders and create a table of what items have sold with what products. My current table that holds the order details is set up like this. orderID, productID, quantity. Any suggestions would be appreceiated.