Results 1 to 3 of 3

Thread: HELP - Moving data across columns

  1. #1
    Join Date
    Jun 2004
    Posts
    5

    HELP - Moving data across columns

    Hi

    I've recently inherited a database at work, containing all sorts of data relating to students at a college.

    Someone has gone nuts, on this DB and created loads of unnecessary columns. Most of them i can simply delete, though some have got relevant information in them.

    Is there a way i can copy this data across to a different column in a different table.

    Thanks in advance for you help

    Cheers

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Yes,

    You can use INSERT INTO table1.. SELECT .. FROM table2

    to copy data from one table to another.

  3. #3
    Join Date
    Jun 2004
    Posts
    5
    Thanks. Thats a great help


Posting Permissions

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