On 14-May-07, at 4:30 PM, Chris Griffin wrote:
> Yea that was where I was heading. I guess I'll just have to
> experiment on the exact SQL. :-)
If you have table1 in both and want to update the "original" they
should have some key field in common
you should be able to update with something like
update table1 set column = attachedDB.table1.column where table1.key
= attacheddb.table1.key and attacheddb.table1.modify_date >
table1.modify_date
if there are rows that are in the attached that have no counterpart
you'd want to add them with an insert
insert into table1 (column ) values ( select
attachedDB.table1.column from attacheddb.table1 where
attacheddb.table1.key not in (select table1.key from table1 ) )
or something along these lines :)
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
