Barring any missing criteria, this should be an UPDATE...FROM query:

UPDATE Destination

SET Destination.d = Source.a

FROM Destination

INNER JOIN Source

ON Destination.e = Source.b

Test this first, of course, before firing it off as an actual UPDATE.