RE: SQL select, join, and count(*)

["Jeff Crosby" <jlcrosby@xxxxxxxxxxxxxxxx>]

> Jeff, it seems to me that you want to be sure that the first 
> receipt for an item was today.  I'd probably do a MIN() on 
> the receipt fate field in DMRECHST grouping by item and 
> warehouse, and if that minimum value is today, then the item 
> was received for the first time today.

Oooh.  I tried this in iNav and it ran for about 10 minutes:

Select * from dbmstf.DMITMMST 
Where ITNBR in 
(Select RHITEM From dbmstf.DMRECHST 
 Group By RHITEM 
 Having Min(RHSYSD) = '2006-06-22') 
Order By WHSLC, ITNBR

I got impatient and tried it in STRSQL.  I think it was looking at all
108,000 records in receipt history for each and every item.  Cancelled them
both.  There's something I'm not getting here.