update row with combination of fields in same row

[ronhud]

I have a Firebird database with about 100 tables with identical structure.  A table has rows which contain a Date column , a Time column and a Timestamp column.   I want to update the Timestamp by combining the Date and Time coulmns for that row.    I can find examples of using two different tables for this but not so far for the same table.  I thought of a SQLQuery with update and select but I cant see how to combine these in the one statement .

[ttomas]

This is FirebirdSQL question

Code: Pascal  [Select][+][-]

1. update table1 set mytimestampfield=mydatefield+mytimefield

[ronhud]

thanks so simple!