Lloyd,
Lloyd Thomas wrote:
Thanks Paul,
I have used that example before to recreate a table. Can I use the same thing to recreate a table and populate a new column with data from a select query.
The table I wish to recreate has an ID number in it and I wish to use this to get the forename and surname from another table.
Yes, you can.
http://www.sqlite.org/lang.html
Both the INSERT statement and the CREATE TABLE statement will let you choose values from a SELECT statement. See the syntax of each at this URL:
http://www.sqlite.org/lang.html
HTH
Ulrik P.
-- Ulrik Petersen, MA, B.Sc. University of Aalborg, Denmark
