Professional Web Applications Themes

How to merger tables? - Microsoft SQL / MS SQL Server

Hi there: I have four tables with the same columns, how to merger them to one? Thanks! CM...

Sponsored Links
  1. #1

    Default How to merger tables?

    Hi there:
    I have four tables with the same columns, how to merger them to one?
    Thanks!
    CM


    Sponsored Links
    CM Guest

  2. #2

    Default Re: How to merger tables?

    Thank you!

    "David Portas" <REMOVE_BEFORE_REPLYING_dportasacm.org> wrote in message
    news:#aLfEtZRDHA.2020TK2MSFTNGP11.phx.gbl...
    > INSERT INTO Newtable (col1, col2, col3)
    > SELECT col1, col2, col3
    > FROM Table1
    > UNION ALL
    > SELECT col1, col2, col3
    > FROM Table2
    > UNION ALL
    > SELECT col1, col2, col3
    > FROM Table3
    > UNION ALL
    > SELECT col1, col2, col3
    > FROM Table4
    >
    > --
    > David Portas
    > ------------
    > Please reply only to the newsgroup
    > --
    >
    > "CM" <caomin111hotmail.com> wrote in message
    > news:ungEBpZRDHA.3796tk2msftngp13.phx.gbl...
    > > Hi there:
    > > I have four tables with the same columns, how to merger them to one?
    > > Thanks!
    > > CM
    > >
    > >
    >
    >

    CM Guest

Similar Threads

  1. Help With Tables
    By Tarvardian webforumsuser@macromedia.com in forum HTML & CSS
    Replies: 2
    Last Post: August 22nd, 02:45 PM
  2. Tables - do we really need them?
    By henryd in forum Macromedia Dynamic HTML
    Replies: 11
    Last Post: March 4th, 07:18 PM
  3. Again tables!
    By Discover@adobeforums.com in forum Adobe Indesign Windows
    Replies: 6
    Last Post: June 4th, 04:32 PM
  4. SQL tables
    By MSM in forum PHP Development
    Replies: 2
    Last Post: September 19th, 12:28 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139