Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2003
    Posts
    43

    Unanswered: concatenating 4 tables in one table

    HI
    HOw do I concatenate 4 tables(a,b,c,d) into one table(z), I tried to do the insert into table z but when I tried to concatenate table b into Z it said table z exists. I am not sure if join will work..and union I dont want to work..as my original 4 tables might get modified which I dont want to
    Can some one help

  2. #2
    Join Date
    Feb 2002
    Location
    Sweden
    Posts
    34
    Need more info!
    Is there a key in the four tables that uniqely(spelled right?) identifies a record?
    Is the record count the same for all tables?
    - Jonte

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Are you concatenating records or columns?

    blindman

Posting Permissions

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