hello, i have this table Products in which i need to update the column “Validation”.
For every product ID i have different quote number and for each of them the quota might be expired or valid.
My customers want me to put for every Product ID, “valid” in the column Validation even if for a certain quote number i have expired.
For example the Product ID =105. it has 4 different quote numbers. For 2 of them the Quote is valid and for 2 is expired. Even if this product ID has 2 expired quotes, they want to see valid because the Quote column has at least one quote number valid.
So, if in the Quote column i have at least one valid quote number and the rest are expired, tehy want to see valid in the validation column.