How do I add the contents of one table to another table? I have two
"identical" tables, each in a different data base. I need to routinely
empty Table B and add the contents of Table A to Table B (actually a
subset of the contents of Table A to Tabnle B). I think I can empty
Table B by using a selection criteria general enough in the "Delete"
action to catch all the indexed records (e.g., >=1 for the auto
increment index field should catch all the records in the Table). There
is bound to be a simple way to use the "Insert" action to add the
contents of Table A to Table B. Or not. Any suggestions will be
greatly appreciated.
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body