>Somebody know the exact syntax for updating a table from a select

The usual SQL syntac for that type of thing is:

UPDATE table1 SET field = (SELECT field FROM TABLE2)

You can add WHERE conditions and what not within each query.

Hope that helps.

Best,

jody