INSERT INTO STATEMENT

From: Peta Griffith <peta_at_dataspeed.com.au>
Date: Thu, 14 Nov 2002 12:47:53 +1100
Message-ID: <_8DA9.76154$g9.214986@newsfeeds.bigpond.com>

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 Wed Nov 13 2002 - 19:47:53 CST