Have created a new SQL table and need a query to enable me to copy all the data from some of the fields in the old table into the new table. The column names are the same in both tables.
Sounds like this breaks the rules of normalisation, but hey...<BR><BR>INSERT INTO myTable (val1, val2)<BR> VALUES<BR> SELECT val1, val2 FROM myOldTable<BR> WHERE val3 = 1;<BR><BR>Something like that?<BR><BR>Craig.
Nearly right. This did it<BR>INSERT myTable (val1, val2) <BR>SELECT val1, val2 FROM myOldTable <BR> <BR>Thanks a lot.