>A simple case: I have a table with two relevant fields, and (month is represented as YYYYMM). This table has history for each part, starting from the current month and going back to some date in the foggy past. > >For each partno, how do I determine the last for that part nothat is NOT found in the table?
Jim,
I'm not sure I understand you correctly but would this work for you (pseudo code)?
SELECT partno, MAX(GOMONTH(YYYYMM, 1)) AS lastmonsplusone ;
...
GROUPBY partno