RE: Getting single record for each new group.

<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.