When Trying to update the above Query in MS SQL SERVER ,it is saying ZERO rows affected
<pre><code>Update a 
set approvedby = 'Matt Schmitt', changenumber = 'CHG48038', effectiveenddatetime = 'DEC  31 2199 11:59PM' 
from esg_staging..enoc_auditexceptions a 
join esg_staging..enoc_auditresult b 
on a.[WorkdayValue] = b.workdayvalue 
    and a.[Applicationvalue] = b.applicationvalue 
    and a.name = b.name 
    and a.workdayid = b.workdayid 
    and a.email = b.email 
    and a.application = '29905'
</code></pre>