13 Replies Latest reply: Nov 26, 2013 4:10 PM by Zach Paz RSS

    JOINING Tables Issue... Please Help!

    Zach Paz

      Hello,


      I am trying to combine to tables as follows:


      Table1 Contains:

      geoid     Distance     Institution

      01          1                       a

      02          3                       a

      03          6                       a

      01          4                        b

      03          7                        b


      Table2 Contains:

      Institution     Company     Program     Degree

      a                   aa                51               1

      a                   aa                47               1

      a                   aa                47               2

      b                   bb               13               3

      b                   bb               13               5


      I Need the final table to look like this:

      Institution     Company     Program     Degree     Geoid     Distance

      a                   aa                51               1               01           1

      a                   aa                51               1               02           3

      a                   aa                51               1               03           6

      a                   aa                47               1               01           1

      a                   aa                47               1               02           3

      a                   aa                47               1               03           6

      a                   aa                47               2               01           1

      a                   aa                47               2               02           3

      a                   aa                47               2               03           6

      b                   bb               13               3               01           4

      b                   bb               13               3               03           7

      b                   bb               13               5               01           4

      b                   bb               13               5               03           7

       

      This is the Load Script I have right now:


      Table1:

      LOAD geoid,
            Distance,
            Institution
      FROM [C:\doc.xlsx]

      outer join

      Table2:
      LOAD Institution,
            Company,
            Program,
            Degree
      FROM [C:\doc.xlsx]

       

       

      Thanks in advance!