Inserting Data - Using INSERT with select

[humpo]

(using mysql)

Trying to insert records into a new table but also insert a value which does not exist in the old table

This simple example works fine, but i can’t see how i could insert values which don’t come from the oldTable
INSERT INTO newTable (field1,field3,field4)
SELECT field1, field3, field4
FROM oldTable;

newTable has an extra field called newID which i would like to populate at the same time.
Something like this:
INSERT INTO newTable (field1,field3,field4, $newID)
SELECT field1, field3, field4
FROM oldTable;

Any ideas?

Thanks

[txbakers]

"INSERT into table1 (f1,f2,f3,f4) SELECT f1,f2,f3," & $newID & " FROM table2 WHERE......."

you need to break the SQL string into parts to include the variable like you want to.

[humpo]

thanks txbakers