Home Forums SQL Server 2012 SQL 2012 - General Merge two tables into one. RE: Merge two tables into one.

  • February 18, 2014 at 4:52 am

    #1689830

    artistdedigital (2/18/2014)

    Hi all,

    I have two totally different tables with completely different data fields. Also, there is no common relationship between these two tables. However, I want to pick few data fields from the each table and merge into a new table! Is this even possible? If so how can I do that?

    Thanks.

    Absolutely:

    SELECT t1.Col1, t1.Col2, t2.Col3, t2.Col4

    INTO Table3

    FROM Table1 AS t1

    , Table2 AS t2

    It will create for you new table (Table3) as nice Cartesian product of Table1 and Table2.

    Is it not what you rally looking after? Not surprised at all...

    Please check the article from the link at the bottom of my signature. I hope it will help you to explain you issue in a way to attract more relevant answers.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]