Hi,
I have a table which I want to update thus:
If d_date is has a value and b_date is 30 or more then set d_date as the min value already in d_date. I know that the WHERE EXISTS clause is wrong but I don't know how to make this work.
UPDATE table
SET d_date =
(
SELECT min(d_date)
FROM table
)
WHERE EXISTS
(
SELECT floor( MONTHS_BETWEEN (SYSDATE, b_date) / 12 )
FROM agents
WHERE floor( MONTHS_BETWEEN (SYSDATE, b_date) / 12 ) >=30
)
AND d_date IS NOT NULL