How to do this selective update?

revdpoel · New User Joined: 01 Nov 2006 Posts: 56

Key1 Key2 Month Indication Description
A1 B1 2 N Aaaaaaaaaaa
A1 B1 3 J Bbbbbbbb
A1 B1 4 N Cccccccccccc
A1 B1 5 J Dddddddddd
A2 B2 2 J Eeeeeeeeeeee
A2 B2 3 J fffffffffffffff

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.

dick scherrer · Posted: Sat Oct 27, 2007 12:45 am

Hello revdpoel and welcome to the forums,

If you use a meaningful subject, you will get more and better responses.

Your subject will not attract so many viewers. "Please help me solve this" provides no hint of the actual question.

I'll change the subject and you can post a reply if you prefer a different subject - you know your requirement better than i do

revdpoel · New User Joined: 01 Nov 2006 Posts: 56

Thanks Dick
title is allright