Yes, not with this one. But then you have NULL for LCopy for REPONDANT.IRESIDENTID == 2, as I said if you are satisfied with the result use it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.