RE: Getting single record for each new group.

["Alan Campin" <Alan.Campin@xxxxxxxxxxxxxxxx>]

<snip>
Select t1.POPLWH,                   
       t1.POITM,                    
       t1.ITRV,                   
      (Select Min(t2.POSTD) As PlanDate
         From PLNORD t2     
         Where t1.POPLWH = t2.POPLWH And                   
               t1.POITM  = t2.POITM  And                   
               t1.ITRV   = t2.ITRV ) As PlanDate           
  From PLNORD t1                                         
  Where t1.PMCDE  = 'M' And
        t1.POPLWH = '1'               
  Group By t1.POPLWH,
           t1.POITM,
           t1.ITRV                  

Seems this would be more straightforward:

Select POPLWH,                   
       POITM,                    
       ITRV,
       Min(POSTD) As PlanDate
  From PLNORD
  Where PMCDE  = 'M' And
        POPLWH = '1'               
  Group By POPLWH,
           POITM,
           ITRV
</snip>

Ops. Right you are but I do seem to remember there was some other
complication. The king has entered the building! :)

I just think the concept of virtual fields is slick and that SQL can
figure it all out. I saw an example going three levels deep to calculate
a value. 

I cannot even begin to imagine the code to compile something like this.
My hats are off to the SQL folks at IBM.