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.

• Next in forum: Re: Searching a datetime field by time
• Prev in forum: Re: Convert Text to Int
• Thread view: Re: SQL Query

[Reply to this message]