to update a table??

[virdee]

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 --

[Yadira]

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 --