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
[Back to original message]
|