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

• Messages sorted by: [ date ][ thread ][ subject ][ author ]
• Previous message: Jeff Woods: "Re: [NTISP] how do they do this?"
• Next message: Dale E. Reed Jr.: "Re: [NTISP] how do they do this?"

> 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
go

Have Fun!
Peter

• Previous message: Jeff Woods: "Re: [NTISP] how do they do this?"
• Next message: Dale E. Reed Jr.: "Re: [NTISP] how do they do this?"