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 and a product ID, but nothing related to "items". You might want to provide more information.
Any suggestions would be appreceiated.
Thanks, Chuck
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
