Re: [NTISP] SQL STATEMENT to insert records into a table from another

Peter Deacon ( )
Sun, 2 May 1999 17:27:26 -0700 (Pacific Daylight Time)

On Wed, 2 Dec 1998, Terry Bomersbach wrote:

> Okay, seems easy enough but it's not working. I know how to create a
> new table with a select statement. Now I want to add addtional
> records to an existing table. This is what I tried, but the table
> already exists so no luck:

> SELECT * INTO DASubAccounts FROM SubAccounts where
> SAExpireDate<'4/1/99'

> Can anyone offer a hint on where I need to change the statement so
> that it INSERTs the records to the existing table?

Here goes...

INSERT INTO DASubAccounts (one,two,three,four)
SELECT one,two,three,four FROM SubAccounts

Have Fun!