Home Forums SQL Server 2012 SQL 2012 - General combining three tables RE: combining three tables

  • January 19, 2017 at 2:45 pm

    #1923881

    cabo 84147 - Wednesday, January 18, 2017 10:56 PM

    We have a 3 tables (1st with 12 cols, 2nd with 20 cols, and 3rd with 14 columns) from different sources which we are currently combining in excel.
    Each table has a customerid as the key field and has the same number of records.  
    I wanted to get assistance with a query I can use to combine these tables resulting in a view/output of a single result set with  12+20+14 = 46 columns.<

    Sounds like homework, but if the tables are indeed as you describe, have you tried using an INNER JOIN from the first table to both the 2nd and 3rd on the customerid field?
    Try it and if you have trouble, post the query you tried and what results you got and we'll try to help.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)