Posted by pamela fluente on 02/20/07 15:31

Hi, I would like to know how to modify the following selects
so that - assuming that NewTable already exists - the result of the
SELECT is appended to the existing table.

If possible I need the appropriate changes for both the 2 syntax
below.

-1-
SELECT * INTO NewTable FROM (
SELECT
S.OrderID AS "OrderID",
S.CustomerID AS "CustomerID"
FROM
Source1 S
) tmp

-2-
CREATE TABLE NewTable
SELECT
S.OrderID AS "OrderID",
S.CustomerID AS "CustomerID"
FROM
Source1 S


Thank you very much for any help,

Pam

• Next in forum: Restore SQL DB with correct logical file names
• Prev in forum: Re: Stored procedure
• Thread view: simple SQL question to insert records in an existing table - Newbie

[Reply to this message]