Two tables, moving information

Results 1 to 2 of 2

Thread: Two tables, moving information

  1. #1
    Join Date
    Dec 1969
    Posts
    105

    Default Two tables, moving information

    How can I move data from one table into another?

  2. #2
    John Weeflaar Guest

    Default RE: Two tables, moving information

    You can use INSERT INTO of the SQL statement.<BR>To copy data from table A to table B (the field data types<BR>of the 2 tables have to be the same):<BR><BR>INSERT INTO TableB (fieldB1, fieldB2, fieldB3)<BR>SELECT fieldA1, fieldA2, fieldA3<BR>FROM TableA<BR><BR>fieldA1 has the same data type as fieldB1<BR>fieldA2 ----------------------------&#062; fieldB2<BR>fieldA3 ----------------------------&#062; fieldB3<BR><BR>John<BR>

Posting Permissions

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