inserting data from one table to another

[babeo]

Hi
I have 2 tables(TabA and TabB) link by a common/index field A. I would like to dump the data of TabB, column SmallFieldB(char) onto TabA, column BigFieldA(char) accordingly using the index key to match up the field. I don't want to do data entry (it's huge data), could anyone help me in coding to do this task (I can think of the logic, but not master about the Sybase syntax)

Thanks a lot.

 

[Guest_imported]

For what I've understood this could help.

update TabA
set BigFieldA = SmallFieldB
from TabA, TabB
where TabA.A = TabB.A

Regards,
Roberto