I have this table.
For each key I have to search the record with the lowest month and indication J. From there on I have to change records. That means for key A1-B1 that I have to change the records for month 3, 4 and 5. Changing has to start with 3, then 4 and then 5.
For key A2-B2 I have to change both records, because the lowest month 2 has indication J
How do I programme this?? Correlated subquery? How then?? Please heldp.