Ooops - addendum: INSERT INTO TABLE1 (field1Name, field2Name, field3Name) SELECT correspondingField1Name, correspondingField2Name, correspondingField3Name FROM TABLE2
That should work, but I didn't try it to make sure. Chris Tifer ----- Original Message ----- From: "Steve Abaffy" <[EMAIL PROTECTED]> To: "ActiveServerPages" <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 1:16 PM Subject: OT: How to Insert into Table from another table > hello, > > I have read the documentation that comes with SQL Books on Line and can't > make heads or tails of it. > I have a table tempOrderTable, and I would like to copy it's contents into > the CustomerProducts table. > The columns in the tables are not in the same order in both tables. > What is the correct SQL Statement to do that??? > > > > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to %%email.unsub%% > --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
