By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

Merge Query

P: 78
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.
Mar 22 '12 #1
Share this Question
Share on Google+
1 Reply


100+
P: 1,059
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)
Mar 30 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.