Jul 9, 2003 #1 redcare Technical User May 20, 2001 32 0 0 GB Hi Iam trying to add records from one table to another using the INSERT Statement. INSERT INTO Test [Server Name],[Server Location],[Asset Number], FROM latest If anybody Can advise on the correct syntax I would be grateful.
Hi Iam trying to add records from one table to another using the INSERT Statement. INSERT INTO Test [Server Name],[Server Location],[Asset Number], FROM latest If anybody Can advise on the correct syntax I would be grateful.
Jul 9, 2003 #2 swampBoogie Programmer Jan 6, 2003 1,660 0 0 SE Code: insert into t1(c1,c2) select c3,c4 from t2 Upvote 0 Downvote
Jul 9, 2003 Thread starter #3 redcare Technical User May 20, 2001 32 0 0 GB Excellent, that worked a treat. Thanks very much. Upvote 0 Downvote