Hi.
Is it possible to update a table's field from another one's? I mean, something like... (I know this doesn't work, ok??)

update mytable set myfield = othertable.otherfield where othertable.keyfield=mytable.keyfield

Thanks a lot in advance...