Posted by Jens on 01/13/06 00:10

Hi Jack,

this is sure untested but should go something like this:

Select COUNT(*), producName,ProductOptions, KeyAccess
>From Orders
Inner join OrderDetails
ON Order.OrderId = OrderDetails.orderId
Group by producName,ProductOptions, KeyAccess

HTH, Jens Suessmeyer.

[Back to original message]