Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    1

    Unanswered: How do I move the records of a column of Table1 to Table2 by creating the column

    Hi,

    I have got two tables: Table1 and Table2

    I need to move the column(say col1) records of Table1 to Table2.
    Note: col1 does not exists in Table2. So I need to add the column col1 to Table2 and then move the records of col1 from Table1 to Table2.
    Please suggest me as to how to proceed with this...

    Thanx in advance.

    Dev.

  2. #2
    Join Date
    Mar 2009
    Posts
    11
    It depends...

    Are the rows in both tables already in sorted order?

    If not, is there an index or other type of record identifier in both tables that can be used to determine which column/row value from Table1 should go with which record in Table2 after the new column has been added?

Posting Permissions

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