INSERT INTO STATEMENT
From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 14 Nov 2002 12:48:22 +1100
Message-ID: <q9DA9.76155$g9.214693_at_newsfeeds.bigpond.com>
[Quoted] Hi All,
Date: Thu, 14 Nov 2002 12:48:22 +1100
Message-ID: <q9DA9.76155$g9.214693_at_newsfeeds.bigpond.com>
[Quoted] Hi All,
I am have trouble coding a Insert Into Statement
the below statements is basic example of the SQL
INSERT INTO TEST1 ( ID,DESCRIPTION) SELECT TEST.ID,TEST.DESCRIPTION WHERE
TEST.ID =5
INSERT INTO TEST1 ( ID,DESCRIPTION) VALUES(SELECT TEST.ID,TEST.DESCRIPTION
WHERE TEST.ID =5)
i am trying to copy the detail from on table to another with exact
structures
if anyone knows the correct syntax or a better method for this it would be
much appreciated
Cheers
Paul
Received on Thu Nov 14 2002 - 02:48:22 CET