I have a question on how to set a field value in multiple records where there is a specific key, when a condition is meet within multiple records.
I have a table 'A', it contains 4 fields:
I will have multiple records with the same TEAM_NAME(key). I want to set the TEAM_STATUS to 'Y' in each team record, only when ALL of the individual PLAYER_STATUS for that team is 'Y'.
Thanks in advance.