Merge Query

[wisni1rr]

I was wondering how I could merge two tables that are serving as a 1:1 relationship (although, no relationship is defined).

[TableA]
ID,field1,field2,field3
[TableB]
ID,field4,field5

The query would check for matching ID. If there is a match, TableA Should be amended with the results of TableB.

The final result would be:
[TableA]
ID,field1,field2,field3,field4,field5

After this, TableB would be deleted.

[johny10151981]

What programming language are you using as front end?

anyway redefine your table structure with field4,field5

and then update all the column with the data from the other table.

and then simply drop the second table. you can also run a verify program to verify them(no need)