Hi,
I wana update a table in my database using a value from antoher. The query I tried is below.
update `standard bond`
SET `standard bond`.payday = day(`securities main`.matdate)
from `standard bond`, `securities main`
WHERE `standard bond`.seccode = `securities main`.seccode
Any idea? what to do now?
thank you!
-- This message may have been cut off and the rest will only be shown to members. To become a member, click here --