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

Terry Bomersbach ( (no email) )
Wed, 2 Dec 1998 17:26:55 -0600

This is a multi-part message in MIME format.

------=_NextPart_000_0071_01BE1E18.F5293740
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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?

------=_NextPart_000_0071_01BE1E18.F5293740
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

Okay, seems easy enough but it's not =working.  I know how to create a new table with a select =statement. =20Now I want to add addtional records to an existing table.  This is =what I=20tried, but the table already exists so no luck:
 
    SELECT * INTO =DASubAccounts=20FROM SubAccounts where SAExpireDate<'4/1/99'
 
Can anyone offer a hint on where I =need to=20change the statement so that it INSERTs the records to the existing=20table?
------=_NextPart_000_0071_01BE1E18.F5293740--