try like this:
update `standard bond`, `securities main`
SET `standard bond`.payday = day(`securities main`.matdate)
WHERE `standard bond`.seccode = `securities main`.seccode;
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --