Re: HELP: merging tables

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/12/16
Message-ID: <67591t$bv7@bgtnsc01.worldnet.att.net>#1/1

Try this:

INSERT INTO main_table (col1,col2,col3,....,col(n-m)) SELECT * FROM subset_table;

Hope this helps.

Michael Serbanescu

---

 On 15 Dec 1997 16:16:24 GMT, callagha_at_cs.fsu.edu (Geoffrey Callaghan) wrote:

>I'm looking for an easy way to merge two tables. Essentially, it is an
>append-update between two nearly identical tables. The table with the new
>data is a subset of the main table. Any ideas, anyone?
>
> Geoff Callaghan
> callagha_at_cs.fsu.edu
Received on Tue Dec 16 1997 - 00:00:00 CST