Insert into from another table

Results 1 to 2 of 2

Thread: Insert into from another table

  1. #1
    Join Date
    Dec 1969

    Default Insert into from another table

    Hi,<BR><BR>My problem is this. I need to copy the contents of one table to another and then delete the records from the old table. The way i am doing it at the moment works but its very over complicated. I have looked at using the insert into from statement but it just seems to fall over everytime. ANyone got any ideas

  2. #2
    Nils Bilhorn Guest

    Default RE: Insert into from another table

    What is the problem, syntax errors? not right data ?<BR>Could you be a bit more specific in this, please.<BR><BR>An example of insert with a select<BR><BR> insert into newtables(c1,c2) <BR> select c3,c4 from oldtable<BR> where c5 = 10 or c6 = 22

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts