I have two tables in different databases on the same database server. Both the databases have the same structure, but different data. Database1 Test1 is the latest. Oracle SQL Update a table with data from another table. If your table t. 1 and its backup t. In addition, my related problem was that only some of the columns were modified and many rows had no edits to these columns, so I wanted to leave those alone basically restore a subset of columns from a backup of the entire table. I have one table A has column id, field1,field2, and another table B has column id,field2 Now I want to merge table B to A, that means i want to update field2. If your table t1 and its backup t2 have many columns, heres a compact way to do it. In addition, my related problem was that only some of the columns were modified. Access/query/graphics/CrosstabQuery.jpg' alt='Update Table From Another Database Table In Sql' title='Update Table From Another Database Table In Sql' />If you want to just restore all rows, skip the where clause. Of course the simpler way would be to delete and insert as select, but in my case I needed a solution with just updates. The trick is that when you do select from a pair of tables with duplicate column names, the 2nd one will get named 1. So heres what I came up with update. Update Table From Another Database Table In Sql' title='Update Table From Another Database Table In Sql' />Ive use an SQL utility on the AS400 call SEQUEL by ASC, that allows updating of values in one table from values in another joined table. The syntax is. SQL Database Glossary. Our database glossary explains common database terminology and SQL database jargon. A. Access. Microsoft Access is an entrylevel database. Windows Server 2003 Enterprise Edition Product Key. SQLs UPDATE statement makes it easy to update one or more records in a database table. The most common UPDATE statement pattern assigns static or parameterized.