|
-
November 1st, 2009, 07:53 PM
#1
How to update one table with the different elements of table1-table2
I have 2 databases.
Table in database 1 has 5 fields
Table in database 2 has 15 fields
I made 2 querys that retrieve the 5 fields from the first and 5 fields from the second that are the same from the first.
I need to update data in Table1 with elements present in table2 that arent in table1 without deleting elements in Table1.
Something like Table1=Table1-Table2 (so I update the table).
How can I do this?
thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|